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  