Question
Prepare a projected income statements for MSC for Year 8Year 12. Also forecast the nancial statements for each of these years under three scenarios: (1)
Prepare a projected income statements for MSC for Year 8Year 12. Also forecast the nancial statements for each of these years under three scenarios: (1) best case, (2) most likely, and (3) worst case.
Development Costs MSC plans to develop two gas stove models, but not concurrently. It will develop the rst gas model during Year 8 and begin selling it during Year 9. It will develop the second gas model during Year 9 and begin selling it during Year 10. MSC will capitalize the development costs in the year incurred (Year 8 and Year 9) and amortize them straight-line over ve years, beginning with the year the stove is initially sold (Year 9 and Year 10). Estimated development cost for each stove are as follows:
Best Case: $100,000
Most Likely Case: $120,000
Worst Case: $160,000
Capital Expenditures Capital expenditures, other than development costs, will be as follows: Year 8, $20,000; Year 9, $30,000; Year 10, $30,000; Year 11, $25,000; Year 12, $25,000. Assume a six-year depreciable life, straight-line depreciation, and a full year of depreciation in the year of acquisition
Sales Growth Changes in wood and gas stove sales relative to total sales of the preceding year are as follows:
Because sales of gas stoves will start at zero, the projections of sales should use the preceding growth rates in total sales. The growth rates shown for woodstove sales and gas stove sales simply indicate the components of the total sales increase. Cost of Goods Sold Manufacturing costs of the gas stoves will equal 50% of sales, the same as for woodstoves.
Depreciation will increase for the amortization of the product development costs on the gas stoves and depreciation of additional capital expenditures.
Facilities Rental Income and Facilities Costs Facilities rental income will decrease by 50%beginning in Year 9 when MSC takes over 5,000 square feet of its building now rented to another company and will remain at that reduced level for Year 10Year 12. Facilities costs will increase by $30,000 beginning in Year 9 for facilities costs now paid by a tenant and for additional facilities costs required by gas stove manufacturing. These costs will remain at that increased level for Year 10Year 12
Administrative Expenses Administrative expenses will increase by $30,000 in Year 8, $30,000in Year 9, and $20,000 in Year 10, and then will remain at the Year 10 level in Years 11 and 12.
Interest Income MSC will earn 5% interest on the average balance in cash each year.
Interest Expense The interest rate on interest-bearing debt will be 6.8% on the average amount of debt outstanding each year.
Income Tax Expense MSC is subject to an income tax rate of 28%.
PLEASE DO NOT USE ANY DATA THAT HAS ALREADY BEEN SUBMITTED FOR THIS QUESTION PREVIOUSLY. ONLY NEW & ORIGINAL WORK. THANK YOU!
Sales Growth Changes in wood and gas stove sales relative to total sales of the preceding year are as follows: Selling Expenses Selling expenses as a percentage of sales are as follows: Sales Growth Changes in wood and gas stove sales relative to total sales of the preceding year are as follows: Selling Expenses Selling expenses as a percentage of sales are as follows
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started