Question: Hello, i have completed this sheet with all the calculations. I just want to make sure i am doing it correctly and the sheet is

Hello, i have completed this sheet with all the calculations. I just want to make sure i am doing it correctly and the sheet is balanced. In particular, i need help to make sure my cash, gross PPE are calculated correctly. \begin{tabular}{|l|c|c|c|}
\hline Income Statement (M\$) & Y0 & Y1 & Forecast Basis \\
\hline Sales & 87,696 & & \(5\%\) growth \\
\hline Cost of Goods Sold & \((19,940)\) & & \(23\%\) of sales \\
\hline Depreciation Expense & \((6,903)\) & & \(8\%\) of sales \\
\hline Selling, General and Administrative Expenses (SG\&A) & \((37,704)\) & & \(5\%\) growth \\
\hline Earnings Before Interest \& Tax (EBIT) & 23,149 & & \\
\hline Interest Expense & \((769)\) & \((769)\) & Given \\
\hline Non-operating Expenses & \((4,754)\) & \((4754)\) & Given \\
\hline Earnings Before Tax & 17,626 & & \\
\hline Taxes & \((2,942)\) & & \(20\%\) of EBT \\
\hline Net Income & 14,684 & & \\
\hline Dividends & 11,704 & 11,704 & Given \\
\hline
\end{tabular}
\begin{tabular}{|l|c|c|c|}
\hline Balance Sheet (M\$) & Y0 & Y1 & Forecast Basis \\
\hline Cash & 22,927 & & Adjust to balance \\
\hline Accounts Receivable & 14,873 & & \(3\%\) growth \\
\hline Inventories & 15,695 & & \(7\%\) growth \\
\hline Current Assets & 53,495 & & Total \\
\hline Gross Property, Plant and Equipment (PPE) & 48,776 & & \\
\hline Accumulated Depreciation & \((27,878)\) & & \\
\hline Net Fixed Assets (Net PPE) & 20,898 & & \(4\%\) growth \\
\hline Other long-term assets & 93,165 & 93,165 & Given \\
\hline TOTAL ASSETS & 167,558 & & Total \\
\hline \hline Accrued Expenses & 33,199 & & \(5\%\) growth \\
\hline Accounts Payable & 9,632 & & \(3\%\) growth \\
\hline Short-term Debt & 3,451 & 3,451 & Given \\
\hline Current Liabilities & 46,282 & & Total \\
\hline Long Term Debt & 26,981 & 26,981 & Given \\
\hline Non-Current Liabilities & 25,521 & 25,521 & Given \\
\hline Common Stock & 3,120 & 3,120 & Given \\
\hline Retained Earnings & 153,843 & & \\
\hline Treasury Securities and other equity & \((88,189)\) & \((88,189)\) & Given \\
\hline Total Liability \& Equity & 167,558 & & Total \\
\hline \hline
\end{tabular}
Hello, i have completed this sheet with all the

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 Accounting Questions!