Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How we do the projection of percent of sales for those years (in yellow) MINOSO CORPORATION Financial Statement Projections Note: Projections Assume New 10% LTD

How we do the projection of percent of sales for those years (in yellow)

image

MINOSO CORPORATION Financial Statement Projections Note: Projections Assume New 10% LTD Financing Ch 9, Prob 6 Income Statements Actual Percent Forecast Percent Forecast Percent 2013 of Sales 2014 of Sales Net Sales $15,000 100.0% $18,000 2015 $21,600 of Sales Forecast Percent 2016 of Sales $25,920 Operating Expenses ($13,000) ($15,600) ($18,720) ($22,464) Interest ($400) ($410) ($519) ($650) EBT $1,600 $1,990 $2,361 $2,806 Taxes (40%) ($640) ($796) ($945) ($1,123) Net Income (NI) $960 $1,194 $1,417 $1,684 Cash Dividends (40% of NI) ($384) ($478) ($567) ($674) Added Retained Earnings $576 $716 $850 $1,010 Balance Sheets $2,013 $2,014 $2,015 $2,016 Required Cash $1,000 $1,200 $1,440 $1,728 Surplus Cash $0 $0 $0 $0 Accounts Rec $2,000 $2,400 $2,880 $3,456 Inventories $2,200 $2,640 $3,168 $3,802 Total Current Assets $5,200 $6,240 $7,488 $8,986 Fixed Assets, Net $6,800 $8,160 $9,792 $11,750 Total Assets $12,000 $14,400 $17,280 $20,736 Accounts Pay $1,600 $1,920 $2,304 $2,765 Bank Loan $1,800 $1,800 $1,800 $1,800 Acc Liab $1,200 $1,440 $1,728 $2,074 Total Current Liab $4,600 $5,160 $5,832 $6,638 New LTD Borrowing (AFN) $0 $1,124 $2,481 $4,121 Long-Term Debt (Old Loan) $2,200 $2,200 $2,200 $2,200 Common Stock $2,400 $2,400 $2,400 $2,400 Retained Earnings $2,800 $3,516 $4,367 $5,377 Total liab & Equity $12,000 $14,400.00 $17,280 $20,736 Selected Ratios: (CL+AFN+LTD)/Total Assets 56.7% 58.9% 60.8% 62.5% (LTD + AFN)/Total Equity 42.3% 56.2% 69.2% 81.3% Net Income/Net Sales 6.4% 6.6% 6.6% 6.5% Net Income/Common Equity 18.5% 20.2% 20.9% 21.7% 0.08

Step by Step Solution

3.33 Rating (147 Votes )

There are 3 Steps involved in it

Step: 1

SOLUTION To project the percent of sales for the years 2016 and beyond we can use the historical dat... 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

Recommended Textbook for

Financial Reporting Financial Statement Analysis and Valuation

Authors: Clyde P. Stickney

6th edition

324302959, 978-0324302967, 324302967, 978-0324302950

More Books

Students also viewed these Finance questions