QUESTION

Text
Image

please do all parts asap

part 1.

According to the screenshot, what formula can you use in order to return the result "NA" instead of the surrent error message? -IF(BI/CI,ERROR, "NA") $=(F(B 1 /(C 1, E R R O R, N A)$ =IFERROR(B1/C1, "NA7) IFERROR(BI/C1,NA)

part 2.


What is the forecasted value of property, plant and equipment (PP\&E) based on the following information: \begin{tabular}{|l|r|} \hline Capital asset turnover ratio & 3.2 \\ \hline Forecasted revenues & 4,600 \\ \hline Forecasted costs of good sold & 2,100 \\ \hline Depreciation & 800 \\ \hline Days in period & 365 \\ \hline \end{tabular} $1,437.5$ $1,031.25$ $1,187.5$ 656.25

part 3



What is the inventory days ratio based on the information below? \begin{tabular}{|l|r|} \hline Revenue & 1,200 \\ \hline Cost of Sales & 700 \\ \hline Net Profit & 250 \\ \hline Inventory & 80 \\ \hline Accounts Payable & 95 \\ \hline Accounts Receivable & 70 \\ \hline \end{tabular} 41.7 24.3 58.4 37.6
part 4

What's the forecasted capital expenditure based on the information below? \begin{tabular}{|l|r|} \hline Net PP\&E beginning of period & 4,200 \\ \hline Net PP\&E end of period & 6,800 \\ \hline Depreciation expense & 900 \\ \hline \end{tabular} 1,700 5,900 3.500 2,600

no need to explain just answer asap

Public Answer

DRA8H7 The First Answerer