Question: Create a common size balance sheet for 2017 and 2018. (% of Assets) Create a common size income statement for 2017 and 2018 (% of

Create a common size balance sheet for 2017 and 2018. (%

Create a common size balance sheet for 2017 and 2018. (% of Assets) Create a common size income statement for 2017 and 2018" (% of Sales) Calculate the ROE for 2017 and 2018. Calculate the ROA for 2017 and 2018. Calculate the Profit margin, Total Asset Turnover and Equity Multiplier for 2017 and 2018. (Dupont Analysis) Create Pro Forma Financial Statements for 2019. 1 4 Assumptions for 2019 Income Statement Sales increase Costs/sales Other expenses/sales Depreciation Interest Taxes Retention ratio 10.00% 35.00% 6.00% $182,000 $88,450 34.00% 50% Assumptions for 2019 Balance sheet Accounts receivable Inventory Net fixed assets Accounts payable Notes payable Long-term debt increase of 1% increase of 4% No change from 2016 No change from 2016 decrease of 25% decrease of 1% decrease of 2% 7 Calculate the five ratios for 2019 (based on Pro Forma statements) Create a common size balance sheet for 2017 and 2018. (% of Assets) Create a common size income statement for 2017 and 2018" (% of Sales) Calculate the ROE for 2017 and 2018. Calculate the ROA for 2017 and 2018. Calculate the Profit margin, Total Asset Turnover and Equity Multiplier for 2017 and 2018. (Dupont Analysis) Create Pro Forma Financial Statements for 2019. 1 4 Assumptions for 2019 Income Statement Sales increase Costs/sales Other expenses/sales Depreciation Interest Taxes Retention ratio 10.00% 35.00% 6.00% $182,000 $88,450 34.00% 50% Assumptions for 2019 Balance sheet Accounts receivable Inventory Net fixed assets Accounts payable Notes payable Long-term debt increase of 1% increase of 4% No change from 2016 No change from 2016 decrease of 25% decrease of 1% decrease of 2% 7 Calculate the five ratios for 2019 (based on Pro Forma statements)

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!

Put the name and NAICS number of the firm you have chosen in the top left cell of your excel page or at the top left of your document page for each of your three firms. No answer sheet is provided....

prepare a common size balance sheet for the current years balance sheet and a common size income statement for the current year's income statement millions current year last year 4451 Partial Grocery...

Section 1: Using the Data from "19x9" column calculate the following ratios, explain what each one means, and show what formula you used. ROE Current ratio Debt to Equity Gross Profit Margin Create a...

missing percentages common sized balance sheet for 2017 and 2018 its the last three pictures After graduating from college in May 2018, Ryan Crews started his career in finance at the W&T...

create a common size balance sheet Create a common size balance sheet for the year 2017 2017 02 2010 (307 3015 2014 2015 2005 53 2000 BSS 3 Balance Sheet Data NASA Cash and cash equivalents...

1. Please answer with excel formulas 2. Create a common size income statement for 2017 and 2018 for Home Depot 3. Perform ratio analysis on your company for 2017 and 2018. a. 5 ratios for each year....

Part B section only. The rest are answers to part A. Accounting 102 final project Select a publicly traded company then gather the following You will need to prepare a typed report that includes the...

please help me to complete the balance sheet Assets 2017 2007 2018 Current assets Cash Accounts receivable Inventory Total $ 34 685 17.951 3.700 $42732 16,425 24,874 SMOLIRA GOLF CORP 2017 and 2018...

this page shows what is required and the instructions wanted from the auto nation financial statement I provided thanks the image is very clear I took photos several times , my phone is very old and...

Please provide the functional dependency diagram for this ERD You can find an example of functional dependency diagram below. Room Room_ID (PK) Room type Room Rate Room Location Number of beds....

Black Diamond Company produces snow skis. Each ski requires 2 pounds of carbon fiber. The companys management predicts that 4,800 skis and 6,100 pounds of carbon fiber will be in inventory on June 30...

Our _ _ _ _ _ _ _ _ _ _ have prepared us to find certain consequences as reinforcing. Group of answer choices learning genes jeans zodiac signs

A regional airline that operates a 50 -seat jet prices the ticket for one popular business flight at $250 If the airline overbooks the reservations, overbooked passengers receive a $300 travel...

The financial area of your life: Where are you living? In what type of home? How much money do you have in savings and investments? What kind of car are you driving?

2. Explain how the Self-Talk Endless Loop in Figure 4.1 can help individuals like Vickie Stringer.

1. In the bright light of hindsight, most of us would probably say we would blow the whistle on these instances had we been a witness to them, especially because there was so much money involved. But...