Question: Part 1. Use the information provided in column H and the assumptions in column M to build a forecast income statement and balance sheet for

 Part 1. Use the information provided in column H and the

Part 1. Use the information provided in column H and the assumptions in column M to build a forecast income statement and balance sheet for 2022. Iterate until your forecast balance sheet balances. Follow the Income Statement Iterations Net Sales Cost of goods sold Gross profit Part 2 Expenses Selling. gener Net interest ex arnings before tax ax arnings after tax vidends alance Sheet \begin{tabular}{|c|c} \hline 1,547 & 12% \\ \hline 90 & 10% \\ \hline 942 & \\ \hline 330 & 35% \\ \hline 612 & \\ \hline 153 & 25% \\ \hline \end{tabular} Iterations Assets 2021E 2022F 2022F 2022F 2022F Current assets Cash and securities Accounts receivable Inventory Prepaid expenses Total current assets Net fixed assets \begin{tabular}{c|c|l|} \hline 636 & 18 & days \\ 1,590 & 45 & days \\ 2,579 & 4 & turnover \\ 18 & Keep constant \end{tabular} Total assets \begin{tabular}{c} 4,822 \\ 300 \\ \hline 5,122 \\ \hline \end{tabular} Liabilities and Dwners' Equity Current liabilities Part 1. Use the information provided in column H and the assumptions in column M to build a forecast income statement and balance sheet for 2022. Iterate until your forecast balance sheet balances. Follow the Income Statement Iterations Net Sales Cost of goods sold Gross profit Part 2 Expenses Selling. gener Net interest ex arnings before tax ax arnings after tax vidends alance Sheet \begin{tabular}{|c|c} \hline 1,547 & 12% \\ \hline 90 & 10% \\ \hline 942 & \\ \hline 330 & 35% \\ \hline 612 & \\ \hline 153 & 25% \\ \hline \end{tabular} Iterations Assets 2021E 2022F 2022F 2022F 2022F Current assets Cash and securities Accounts receivable Inventory Prepaid expenses Total current assets Net fixed assets \begin{tabular}{c|c|l|} \hline 636 & 18 & days \\ 1,590 & 45 & days \\ 2,579 & 4 & turnover \\ 18 & Keep constant \end{tabular} Total assets \begin{tabular}{c} 4,822 \\ 300 \\ \hline 5,122 \\ \hline \end{tabular} Liabilities and Dwners' Equity Current liabilities

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!