See attached

The new-product department of Telephone Accessories, Inc. (TAI) has researched a new multipurpose charging station. Further development (depreciable) to have it ready to sell is estimated at $650,000. Marketing has estimated that it could be sold at a price of $66 and that 80,000 units could be sold each year (in all years). A marketing budget for this new product would need to be $2,000,000 in year 1 and $1,000,000 in the remaining years. A vendor has been found in China who would produce these at an estimated cost of $47.00 each. For this initial analysis, working capital can be ignored and the salvage value would be zero. Is this product financially feasible for the above financial estimates? Use a MARR of 15%. income and capital gains tax rate of 20%, a time horizon of 4 years and straight line depreciation?

Final Exam, Spring Name Question 1 2 3 4 5 6 7 8 9 10 Late Total Score 0 0 0 0 0 0 0 0 0 0 0 0 MACRS Depreciation % 5 year 7 Year 10 year 20.00% 14.29% 10.00% 32.00% 24.49% 18.00% 19.20% 17.49% 14.40% 11.52% 12.49% 11.52% 11.52% 8.93% 9.22% 5.76% 8.92% 7.37% 8.93% 6.55% 4.46% 6.55% 6.56% 6.55% 3.28% Year 3 year 15 Year 20 year 1 33.33% 5.00% 3.750% 2 44.45% 9.50% 7.219% 3 14.81% 8.55% 6.677% 4 7.41% 7.70% 6.177% 5 6.93% 5.713% 6 6.23% 5.285% 7 5.90% 4.888% 8 5.90% 4.522% 9 5.91% 4.462% 10 5.90% 4.461% 11 5.91% 4.462% 12 5.90% 4.461% 13 5.91% 4.462% 14 5.90% 4.461% 15 5.91% 4.462% 16 2.95% 4.461% 17 4.462% 18 4.461% 19 4.462% 20 4.461% 21 2.231% Sum 100.00% 100.00% 100.00% 100.00% 100.00% 100.000% Retrieved from http://www.irs.gov/publications/p946/ar02.html, Question 1 Score 0 The new-product department of Telephone Accessories, Inc. (TAI) has researched a new multipurpose charging station. Further development (depreciable) to have it ready to sell is estimated at $650,000. Marketing has estimated that it could be sold at a price of $66 and that 80,000 units could be sold each year (in all years). A marketing budget for this new product would need to be $2,000,000 in year 1 and $1,000,000 in the remaining years. A vendor has been found in China who would produce these at an estimated cost of $47.00 each. For this initial analysis, working capital can be ignored and the salvage value would be zero. Is this product financially feasible for the above financial estimates? Use a MARR of 15%. income and capital gains tax rate of 20%, a time horizon of 4 years and straight line depreciation? Solution Question 2 Score 0 Gadgets, Inc. is considering two alternative new products. Only one will be offered. Product ABC would require an upfront investment of $50,000 that will not be depreciated, and have zero salvage value the end of year 5. It is forecasted to have revenue of $500,000 in year 1 that would increase by $25,000 annually after year 1. Cost-of-goods-sold would be 60% of revenue. It would require $200,000 annually for SG&A expenses. Working capital requirements can be ignored. Product XYZ would require an upfront investment of $750,000 that will not be depreciated, and zero salvage value in year 5. It is forecasted to have the annual revenues in year 1 of $400,000 and to have that would increase by $100,000 annually after year 1. Cost-of-goods-sold would be 50% of revenue. In addition to these cash flows. It would require $400,000 annually for SG&A expenses. Working capital requirements can be ignored. Which product should be offered if the MARR is 10% and the tax rates are 15%. Use a 5-year time horizon. Explain the rationale for the choice. Solution Question 3 Score 0 Monroe Products, Inc. has an existing \"H\" model whose sales have stagnated. To achieve some growth in Monroe's sales, a new model "XL" has been proposed to be added to their product lines The existing \"H\" model has steady sales of 2,000 units annually, and sells for $2,500 each. This quantity of sales is expected to continue if no changes are made. The COGS for product "H" is $1,900 each and the price of model "H" would not be changed in another model is introduced. A new model "XL" has been proposed that is forecasted to have sales of 200 in year 1, and to double each year after that. Product "XL" will sell for $3,000 each and the COGS would be $2,100. Unfortunately, every unit of "XL" that is sold would result in one less unit of model "H" that is sold. Product "XL": would require an upfront investment of $650,000 in new machines and facilities that would be depreciated over 5 years using MACRS. The salvage value of this investment in 3 years would be $150,000. Working capital is not to be included in the analysis. S.G.&A will be $75,000 with or without the product addition. Monroe uses a MARR of 12%, an income tax rate of 20% and a capital gains tax rate of 15%. A three-year analysis is used for proposals such as this one. From a financial perspective, should the new product be offered? Solution Question 4 Score 0 Modern Medical Mechanics, LLC uses a production machine that periodically needs a major overhaul that costs $75,000. It has been proposed to buy a new machine instead of incurring this major periodic expense. If the new machine is not purchased and the overhaul alternative is chosen, this overhaul expense would be incurred in years 1 and 4 and would be recorded as an expense, not an investment. The present machine has an estimated salvage value of $25,000 whenever sold. The present machine is fully depreciated and the overhaul cost will not affect this zero book value. An alternative to periodic overhauls is to purchase a new machine for $225,000 that would be depreciated using 5-year MACRS.. The estimated salvage value of this new machine would be $100,000 that would be received in year 6. If a new machine is purchased, the old machine would be sold in year 1. Except for the overhaul expense if done, and depreciation if purchased, neither alternative will affect revenues, cost of good sold, and expenses. Modern Medical Mechanics uses an Income tax rate of 0% (since it is a LLC), a capital gains tax rate of 12.5%, and a MARR of 10%. A 5-year time horizon is to be used. Make a recommendation of which alternative should be adopted from a financial perspective and why. Solution Question 5 Score 0 USA Manufacturing, offers a variety of products, and one is a small volume but rapidly growing product that needs an increase in production capacity to keep up with sales increases. It has been proposed to move all production of this product offshore since the in-house production resources used for this product are needed for other products. If offshore production is not possible, the product will be discontinued. Therefore, consider this offshore production a standalone proposal and is not to be compared to keeping production local. Revenues for this product have been increasing by 20% annually and are expected to continue growing at this rate in the future. This year's revenue were $500,000. Sourcing offshore is expected to decrease the COGS to 35% of revenue. Presently (year 0) there is $240,000 of inventory, $130,000 of accounts receivable, and $60,000 of accounts payable. The offshore sourcing will require inventory to be 60% of revenue. Accounts receivable is expected to be 40% of revenue. Accounts payable is expected to be 10% of the revenue. No other working capital items need to be considered. It is expected the that proposal will incur an upfront investment of $250,000 that includes all upfront travel time, vendor evaluations, etc. This upfront investment will not be depreciated and it will not change the ending asset value of the product or company at the end of the time horizon. All production and sales for this product would be sourced offshore starting in year 1. Product management, that presently cost $50,000 annually, will be increased to $130,000 annually to cover additional monitoring of deliveries from offshore and quality. The present marketing expense of $190,000 annually will be continued at this amount. USA Manufacturing uses a MARR of 15%, income tax rate of 25%, capital gain tax rate of 10% and a time horizon for this type of proposal of four years. Determine if the product will be financially viable if offshore production is used. Solution Question 6 Score 0 The A-Plus pharmaceutical company has completed the scientific work on a new product. The investment needed for development of this completed research into a marketable product is being proposed. All the relevant data is shown in the data block and financial statements below. This is followed by the analysis needed to determine the present worth and internal rate of return. a The COGS estimate and particularly the "Cost reduction each year" of $5 has been questioned. Determine the sensitivity of the present worth to this annual reduction. Use values of the "Cost reduction each year" from the forecasted value of $5.00 down to $3.00 in 50 cent intervals. b Determine the "cost of reduction each year" that results in the breakeven present worth (PW = 0). Data Block Investment depreciation salvage value 5-year MACRS Depreciation Book value Ending Asset Value Revenues and COGS Quantity Sold Price each Revenue Cost reduction each year Cost each COGS Expenses SG&A Working Capital Working capital Change in Working Capital Rates and Time Horizon MARR Income Tax rate Capital Gains Tax rate Time Horizon Income Statement Year Revenue COGS Gross Margin SG&A Depreciation EBIT Taxes Net Income Cash Flow Statement Year Operations Net Income Depreciation Total Operations activities Investment Working Capital Working capital Recovery Investment Salvage Ending Value Tax on gain Total Capital activities Cash Flow Present Worth $146,752 Solution $3,500,000 5-year MACRS $0 0 $3,500,000 in year 0 in year 4 1 20.00% $700,000 $2,800,000 2 32.00% $1,120,000 $1,680,000 20000 20000 $100 $100 $2,000,000 $2,000,000 $5.00 starting in year 2 $45 $40 $900,000 $800,000 3 19.20% $672,000 $1,008,000 4 11.52% $403,200 $604,800 $2,000,000 20000 $100 $2,000,000 20000 $100 $2,000,000 $35 $700,000 $30 $600,000 $250,000 $250,000 $250,000 $250,000 $500,000 $500,000 $500,000 $0 $400,000 ($100,000) $350,000 ($50,000) $300,000 ($50,000) 10% 20% 15% 4 years 2 $2,000,000 ($800,000) $1,200,000 ($250,000) ($1,120,000) ($170,000) $34,000 ($136,000) 3 $2,000,000 ($700,000) $1,300,000 ($250,000) ($672,000) $378,000 ($75,600) $302,400 4 $2,000,000 ($600,000) $1,400,000 ($250,000) ($403,200) $746,800 ($149,360) $597,440 0 1 $2,000,000 ($900,000) $1,100,000 ($250,000) ($700,000) $150,000 ($30,000) $120,000 0 1 2 3 4 $0 $120,000 $700,000 $820,000 ($136,000) $1,120,000 $984,000 $302,400 $672,000 $974,400 $597,440 $403,200 $1,000,640 ($500,000) $0 $100,000 $50,000 $50,000 ($300,000) ($3,500,000) ($4,000,000) ($4,000,000) IRR 11.41% $0 $820,000 $100,000 $1,084,000 $50,000 $1,024,400 $0 $2,000,000 ($209,280) $1,540,720 $2,541,360 Salvage Ending Value -Book Value Gain Tax $0 $2,000,000 ($604,800) $1,395,200 ($209,280) Question 7 Score 0 The Department of State Parks and Forests has been notified that that will have an annual 10% budget cut to the present state allotment of $28 million per year. That is, a 10% reduction in year 1, another 10% in year 2, and yet another 10% in year 3. In the past this was their only source of revenue. They have been instructed to start charging entry fees for all State Parks as well as cut staff to make up the difference. Added staff will be needed to collect the fees and process them according to state regulations. The alternative of simply closing some parks is deemed politically unacceptable. The following decisions were made to cope with the reduced state support and the resulting cash flow statement is shown below. Unchanged items are listed below. A fee of $10 will be charged for each visitor. The number of people using the park system was 250,000 in the current year and is forecast to increase 5% annually in future years. The full time staff budget will be reduced by 17.0%. It presently is $8,000,000. Part-time summer workers will be added to man the toll booths and perform other seasonal tasks. This is expected to cost $1,000,000 annually. Also toll booths will be added at a cost of $1 million in year 1 (only). Annual Investment planned for new equipment will be cut in half (reduced by 50%), and equipment maintenance cost will increase by50%. (Constant in all years). Equipment maintenance is performed by outside vendors. Present employees and legislators are questioning this budget and have proposed changes in the following four items. Evaluate and comment concerning the financial viability of these. Park users attendance increase Fee Staff reductions Seasonal Employees Data Block Present State funding State budget cut Future state funding Park users attendance increase Estimated annual users Fee Park Rangers Staff Reductions Employee Cost Seasonal employees Toll Booth Construction Equipment Investment Reduction Equipment Maintenance Increase Income/Cash Flow Statement Revenue State Revenue Fees Total Revenue S.G.& A. Park Rangers Employee Cost Seasonal employees Toll Booth Construction Equipment Investment Equipment Maintenance Total S.G.& A. Cash Flow Beginning Cash Balance Ending cash Balance Proposed 5% $10.00 17% $1,000,000 Employees 10% $12.00 5% $250,000 Legislators 0% $7.50 20% $1,500,000 annually $25,200,000 year 1 $22,680,000 2 $20,412,000 3 275,625 289,406 $16,600,000 $16,600,000 $1,250,000 $1,250,000 $1,250,000 $1,500,000 $1,500,000 $1,500,000 Present $28,000,000 $0 $28,000,000 1 $25,200,000 $2,625,000 $27,825,000 2 $22,680,000 $2,756,250 $25,436,250 3 $20,412,000 $2,894,063 $23,306,063 ($4,500,000) ($20,000,000) $0 $0 ($2,500,000) ($1,000,000) ($28,000,000) $0 $300,000 $300,000 ($4,500,000) ($16,600,000) ($1,000,000) ($2,000,000) ($1,250,000) ($1,500,000) ($26,850,000) $975,000 $300,000 $1,275,000 ($4,500,000) ($16,600,000) ($1,000,000) $0 ($1,250,000) ($1,500,000) ($24,850,000) $586,250 $1,275,000 $1,861,250 ($4,500,000) ($16,600,000) ($1,000,000) $0 ($1,250,000) ($1,500,000) ($24,850,000) ($1,543,938) $1,861,250 $317,313 $28,000,000 10% 5% 250,000 $10.00 $4,500,000 17.0% $20,000,000 $1,000,000 $2,000,000.00 $2,500,000 -50% $1,000,000 50% 262,500 per user years 1-3 one time change $16,600,000 years 1-3 year 1 Question 8 Score 0 The United Way organization of the City of MyTown has raised $800,000 in their annual campaign. Now the United Way board has to allocate these funds based on proposals submitted by a variety of nonprofit organizations. $550,000 of these funds have been awarded to organizations and projects that are ongoing and have shown concrete results. The remaining $250,000 is to be allocated from among new multi-year proposals., which is the task here. Each proposal is required to include a budget that details the monetary benefits, disbenefits, annual operating costs and initial (one-time) startup costs. These are listed below. Determine which should be funded from a financial perspective using a 3-year time horizon and a MARR of 7%. Annual Proposal A B C D E F G Solution Startup costs $48,000 $68,000 $96,000 $24,000 $16,000 $50,000 $35,000 Benefits $36,000 $30,000 $44,000 $31,000 $29,000 $49,000 $15,000 Disbenefits $1,000 $0 $500 $2,000 $1,500 $3,400 $0 Operating Costs $5,000 $5,500 $1,000 $250 $1,200 $1,500 $1,000 Question 9 Score 0 The bridge department of MyTown needs to select bridges to upgrade for the coming year. The cost of upgrades for several bridge are shown below. Also shown are the hours of congestion observed per year on each. The criteria for choosing bridges to be upgraded is to select the set of projects that reduce the most congestion ("biggest bang for the buck") within this year's budget of $5,000,000. Which ones should be upgraded this year. Bridge Washington Adams Jefferson Madison Monroe Jackson Solution Upgrade Costs $2,400,000 $2,700,000 $2,300,000 $2,240,000 $1,400,000 $1,250,000 Congestion hours per year 1,500 1,400 1,640 1,600 1,300 1,440 Question 10 Your small company has recently been purchased by a large corporation and the previous owner has been made the general manager of your plant. He catches you at the coffee machine and says, "The new company keeps talking about this "present value" thing, and you mentioned this in the meeting yesterday? You have all those degrees that I paid for, so explain this to me clearly in terms I can understand, and not with quotes from a textbook or website." Write an explanation for the general manager using an example(s). Limit this to 500 words. Post this in the space below or in a separate MS Word document. Answer Score 0 Reflects tim me value of money, reflects the actual cash flow for the corporation