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 angular position of a point on a rotating disk is given by 9 = (-0.08) + (0.37) + (4.42) t + (48), where 0 is in radians and t is in seconds. What is its angular acceleration in rad/s at t = 45...
-
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...
-
Mainord Corporation issues $1,700,000 of 10-year, 6% convertible bonds. Each $1,000 bond is convertible into 21 common shares. On the date of the issue, the shares had a par value of $15 per share....
-
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...
-
Determine the amount of the late filing and late payment penalties that apply for the following taxpayers. a. Jolene filed her tax return by its original due date but did not pay the $2,000 in taxes...
-
The overall objective of promotion is to stimulate demand for a product. Through television advertising, the American Dairy Association promotes the benefits of drinking milk, a campaign that aims to...
-
Whirlmore, Inc., manufactures and sells washers and dryers through three divisions: Home-Supreme, Apartment, and International. Each division is evaluated as a profit center. Data for each division...
-
upper sum lower sum Illustrate. 2 -T 3 O X 2T T 23 -3 -3 - 513 X 2 T -T 53 "-3 3 X 2T T T 2m | T 3 3 3 3 C
-
Assume that you are the chairman of the Department of Accountancy at Central Manitoba University. One of the accounting professors in your department, Dr. Smith, has been uniformly regarded by...
-
whatis the revenue principle and expense principle that underlies theaccrual basis of accounting? 1 answer
-
Why is it a requirement that a company discloses the amount of interest capitalized in the notes to the financial statements? Not all assets qualify for interest capitalization. Provide some examples...
-
Define the relational model. What is a relational database management system (DBMS)?
-
Alyssa works remotely analyzing statistical data for Azod Software Company. They needs to work with three members of the IT department to resolve a technical issue, but will disband the team once the...
-
You are the new cost accountant for ABX Corporation. After careful review of the company's operations you have been tasked to determine the company's break-even point, the numbers sold to meet the...
-
Why should team members be encouraged to share information by team leaders?
-
1. Kingsway Electronics Inc. is expecting a period of intense growth and has decided to increase the annual dividend by 25% a year for the next three years. After that they will maintain a constant...
-
True & False The basis of an asset must be reduced by the depreciation allowable, 2. Adjusted gross income (AGI) is the basis for a number of phase-outs of deductions. 3. A change to adjusted gross...
-
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...
-
Hudson Company's trial balance as of January 1. the beginning of its fiscal year, is given below: Hudson Company is a manufacturer that uses a job-order costing system. During the year, the following...
-
Gitano Products operates a job-order costing system and applies overhead cost to jobs on the basis of direct materials used in production (not on the basis of raw materials purchased). In computing a...
-
Almeda Products, Inc., uses a job-order cost system. The company's inventory balances on April 1 , the start (3) Underapplied by $4,000 of its fiscal year, were as follows: Required: 1. Prepare...
Study smarter with the SolutionInn App