Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

URGENT, PLEASE!! In a EXCEL spreadsheet. Thank you 2. Pro forma income statements. Green Planet, a restaurant supply company, has the following income statement accounts

URGENT, PLEASE!! In a EXCEL spreadsheet. Thank you image text in transcribedimage text in transcribed

2. Pro forma income statements. Green Planet, a restaurant supply company, has the following income statement accounts for 2017: Revenue $12,345,000 $12 2160 SG & A Costs $1,481,400 Fixed Costs $ 1,975,200 COGS $5,555,250 Interest Expense Depreciation $ 988,320 $ $ 802,425 185,175 Sales Returns Construct the income statement for 2017 with a tax rate of 38%. Then con- struct pro forma income statements for the years 2018, 2019, and 2020 if the company expects projected sales to rise annually at 4.5% and all the accounts have the same percentage of sales as in 2017. Redo the pro forma income statements for 2018, 2019, and 2020 if fixed costs are truly fixed and remain at $1,975,200, but all other accounts listed will be at the same percentage of sales for the next three years as in 2017. Find the growth in net income each year

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions