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. Your Awesome Business Name Income Statement For the Perio! Ended December 31, 2019 Sales Revenue Cost of Goods Sold Gross Profit $90,000 32,000 $58,000 OPERATING EXPENSES Marketing Utilities Insurance Rent Expense Wages & Salaries Total Expenses $1,800 750 1,000 12,000 25,000 $40.550 OPERATING INCOME $17.450 $100 NON OPERATING, OTHER Interest Income Interest Expense Gain/(Loss) (750) 1000 Profit before tax $17,800 Income Tax Expense 3,740 NET INCOME $14,060

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!