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. begintabularlccc
hline Income Statement M$ & Y & Y & Forecast Basis
hline Sales & & & growth
hline Cost of Goods Sold & & & of sales
hline Depreciation Expense & & & of sales
hline Selling, General and Administrative Expenses SG&A & & & growth
hline Earnings Before Interest & Tax EBIT & & &
hline Interest Expense & & & Given
hline Nonoperating Expenses & & & Given
hline Earnings Before Tax & & &
hline Taxes & & & of EBT
hline Net Income & & &
hline Dividends & & & Given
hline
endtabular
begintabularlccc
hline Balance Sheet M$ & Y & Y & Forecast Basis
hline Cash & & & Adjust to balance
hline Accounts Receivable & & & growth
hline Inventories & & & growth
hline Current Assets & & & Total
hline Gross Property, Plant and Equipment PPE & & &
hline Accumulated Depreciation & & &
hline Net Fixed Assets Net PPE & & & growth
hline Other longterm assets & & & Given
hline TOTAL ASSETS & & & Total
hline hline Accrued Expenses & & & growth
hline Accounts Payable & & & growth
hline Shortterm Debt & & & Given
hline Current Liabilities & & & Total
hline Long Term Debt & & & Given
hline NonCurrent Liabilities & & & Given
hline Common Stock & & & Given
hline Retained Earnings & & &
hline Treasury Securities and other equity & & & Given
hline Total Liability & Equity & & & Total
hline hline
endtabular
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
