How we do the projection of percent of sales for those years (in yellow) MINOSO CORPORATION Financial
Fantastic news! We've Found the answer you've been seeking!
Question:
How we do the projection of percent of sales for those years (in yellow)
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To project the percent of sales for the years 2016 and beyond we can use the historical dat... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation
ISBN: 978-0324302950
6th edition
Authors: Clyde P. Stickney
Posted Date:
Students also viewed these finance questions
-
The Pharma Biotech Corporation spent several years working on developing a DHA product that can be used to provide a fatty-acid supplement to a variety of food products. DHA stands for...
-
Is it possible to produce an iron-carbon alloy that has a minimum tensile strength of 690 MPa (100,000 psi) and a minimum ductility of 40%RA? If so, what will be its composition and microstructure...
-
1. How many different meals can be chosen if there are 6 appetizers, 10 main dishes, and 8 desserts, assuming that a meal consists of one item from each category? 2. On an essay test, there are five...
-
Would a dress code that required men to wear three-piece suits, but stated only that women had to look professional, be discriminatory against the male employees? What differences would be considered...
-
Dr. Wayside works at a local clinic as a general practitioner. Because she has significant unsecured debt, Dr. Wayside decided to petition the United States Bankruptcy Court for relief under Chapter...
-
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 49,000 units per year, an ordering cost of $8...
-
Malimali Fish Products Ltd, A Malindi-based firm dealing in fish products, conducts training programmes for all its line managers. The managers ar expected to master, in particular, procedures in...
-
Bill and Kate Theil are not only husband and wife but entrepreneurs who have established three successful businesses. The proposed plan for their latest effort involves a series of international...
-
Hotel worker Danny Ruiz was living with his wife and four children in a cramped New York apartment when he saw a television ad promising the family a way out. "Why rent when you can own your own...
-
What are the elements of a valid contract? describe the principle of good faith in contract law.
-
An investor looking to assess the firm's ability to make profits, pay dividends, and realize share price increases will predominantly focus on Efficiency and profitability ratios Profitability and...
-
Presto Inc. has been carrying on a business since 2008. On November 1,2023, Presto Inc. acquires a franchise for $33,000 . The franchise has a limited life of 12 years. What is the maximum amount of...
-
What will be the cost of an intangible asset that has been acquired by giving up nonmonetary assets, in an exchange that has commercial substance? Select answer from the options below the fair value...
-
The budgeted quantity of direct materials to be purchased equals ______. Multiple choice question. budgeted production (in units) times the number of raw material units per unit of output the number...
-
The Kangal Enterprise needs to increase its working capital by Rs 3.5 million for which it will borrow from the Banque de Fraude at 18% per year, for one year. Banque de Fraude is generously...
-
1A. If the researcher is concerned about the number of variables, the nature of the analysis, and completion rates, then, he/she is at which stage of the sampling design process (Figure 11.1 in the...
-
Financial reporting requires firms to expense immediately all research and development costs (R&D) costs. Alternatively, GAAP could require firms to capitalize and subsequently amortize all...
-
Turner Construction Company agreed on January 1, Year 1, to construct an observatory for Dartmouth College for $120 million. Dartmouth College must pay $30 million on signing and $30 million at the...
-
Prior to Year 14, Borden, Inc. derived approximately 75 percent of its revenues from branded food products and 25 percent from packaging and industrial products. The geographical sales mix comprised...
-
Contrast the assumptions for a finite distributed lag model with those for an infinite distributed lag model.
-
Contrast the exogeneity assumption required for HAC standard errors with that required for estimating an \(\mathrm{AR}(1)\) error model.
-
Test for consistency of least squares in the ARDL representation of an infinite distributed lag model.
Study smarter with the SolutionInn App