Question: In Excel complete the vertical size statement analysis for the statement below and also create a pro forma assuming an 8% growth and also assuming

 In Excel complete the vertical size statement analysis for the statement
below and also create a pro forma assuming an 8% growth and

In Excel complete the vertical size statement analysis for the statement below and also create a pro forma assuming an 8% growth and also assuming that rent is fixed. Once completed upload the completed Excel to this question. Income Statement For the Period Ended December 31, 2019 \begin{tabular}{lr} \hline Sales Revenue & $90,000 \\ Cost of Goods Sold & 32,000 \\ Gross Profit & $58,000 \\ \cline { 2 } OPERATING EXPENSES & \\ Marketing & $1,800 \\ Utilities & 750 \\ Insurance & 1,000 \\ Rent Expense & 12,000 \\ Wages \& Salaries & 25,000 \\ Total Expenses & $40,550 \\ OPERATING INCOME & $17,450 \\ NON OPERATING, OTHER & \\ Interest Income & $100 \\ Interest Expense & (750) \\ Gain/(Loss) & 1000 \\ Profit before tax & $17,800 \\ Income Tax Expense & 3,740 \\ NEt INCOME & $14,060 \\ \hline \end{tabular}

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!