please show work if possible. or show formulas on excel please and thank you!

14%20IntegrativeCase.pdf he RNMKRS Netflix My Drive - Google... Chegg Study Cheg. in Linkedin Candidate Portal D... Nanovo Inc., is a manufacturer of low-cost micro batteries for use in a wide variety of compact electronic devices such as children's toys, wireless transmitters, and sensors. The growth in the use of these devices has steadily increased, leading to an ever greater demand for Nanovo's products. Nanovo has responded to this increase in demand by expanding its production capacity, more than doubling the firm's size over the last decade. Despite this growth, however, Nanovo does not have sufficient capacity to meet the current demand for its ultra-long life, low-voltage batteries. You have been asked to evaluate two proposals to expand one of Nanovo's existing plants and make a recommendation The current plant has a capacity of 250,000 cases per month . Proposal 1 The first proposal is for a major expansion that would double the plant's current capacity to 500.000 cases per month. After talking with the firm's design engineers, sales managers, and plant operators, you have prepared the following estimates: Expanding the plant will require the purchase of $3.6 million in new equipment and entail up-front design and engineering expenses of $3.9 million. These costs will be paid immediately (at Year O) when the expansion begins Installing the new equipment and redesigning the plant to accommodate the higher capacity will require shutting down the plant for nine months. During that time, the plant's production will cease. After the expansion is finished, the plant will operate at double its original capacity. (The production shutdown will occur in Year 1.) Marketing and seling the additional volume will lead to $1 million per year in additional sales, marketing, and administrative costs. These costs will begin in the first year (even while the plant is under construction and shut down). Proposal 2 The engineers have put forth a second proposal for a minor expansion that will increase the firm's capacity by only 60%. to 400,000 cases per month. While the capacity is smaller, such an expansion would be cheaper and less disruptive: The smaller expansion will require only $2.4 million in new equipment, and $1.5 million in design and engineering expenses. The existing plant will need to be shut down for only four months Sales, marketing, and administrative costs will only increase by $500,000. Case.pdf X Netflix NEX 14%20IntegrativeCase.pdf mRNMKRS My Drive. Google Chegg Study Cheg. in Linkedin Candidate Portal Nanovo believes that with or without any expansion, the technology used at the plant will be obsolete arter six years and will have no salvage value, and the plant itself will need to be completely overhauled at that time. You also have the following additional general information: With or without either proposed expansion, Nanovo will be able to sell all it can produce at an average wholesale price of $80 per case. This price is not expected to change during the next six years. Nanovo has a gross profit margin of 55% on these batteries. Nanovo's average net working capital at the end of each year will equal 15% of the projected annual revenue next year. Nanovo pays a 40% corporate tax rate. While all design and engineering costs are immediately deductible as operating expenses, all capital expenditures will be straight-line depreciated for tax purposes over the subsequent six years. Management believes the risk of the expansion is similar to the risk of Nanovo's existing projects, and because Nanovo is all equity financed, the risk of the expansion is also similar to the risk of Nanovo stock. You have the following additional information about the stock: Nanovo has no debt and has 2 million shares outstanding. The firm's current share price is $75 per share. Analysts are expecting Nanovo to pay a $3 dividend at the end of this year (e. D1-$3), and to raise its dividend at an average rate of 8% per year in the future. Based on this information, you have been tasked with preparing expansion recommendations for Nanova. . Case Questions 1. Determine the annual incremental free cash flow associated with each expansion proposal relative to the status quo (no expansion). 2. Compute the IRR and payback period of each expansion proposal. Which plan has a higher IRR? Which has a shorter payback period? 3. Estimate Nanovo's equity cost of capital. Use it to determine the NPV associated with each expansion proposal. Which plan has a higher NPV? 4. Should Nanovo expand the plant? If so, which proposal should Nanovo adopt? Explain 5. If the Nanovo's cost of capital is 16%, how would you choose between the two proposals? Explain 6. Create the NPV profiles for both projects. The NPV of which of the two proposals is more sensitive to errors in the estimation of cost of capital? Explain Complete the calculations necessary for answering 1-6 in Excel. Use the templated provided. 7. Suppose Nanovo decides to do the major expansion. If investors are not expecting this expansion, and if they agree with the forecasts above, how will the stock price change when the expansion is announced? Save OM Home Insert Draw Page Layout Formulas Data Review View Developer Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected Vi XV A D Year 1 E Year 2 F Year 3 Year Yoar 4 Year 6 Year 5 B Information Given es at Current Capacity (# of cases) INCREMENTAL Sales after Expansion of a Average price percase Cost ot new equipment Salvage value Other upfrond costs Gross Marga Incremental Selling General, and Adminstrative Expenses Net Worlung Capital (NOWC) as a % of revenue Taxate of shares outstanding Dividend per share Dividend Browth rate Share price Year 1 Year 2 Year 3 Yoar 4 Yoar 5 Yoar 6 INCREMENTAL proforma Income Statement in thousand Year Revenue Cost of Goods Sold Grous Profit Senin General, and Administrative Expenses Depreciation Other Operating expenses Income Tax incremental Earnings Year o Year 1 Year 2 Yaara Yoar 4 Year 5 Yar 6 Not Operating Working Capital forecast (in thousands of NOWC Change in NOWC Your Year 1 Year 2 Your Year 4 Yoar 5 Year o Incremental Free Cash Flows in thousands of 5) Incremental Earnings Plus Dopeoication Minus Capital Expenditure Mnus Change in NOWC HCF Payback Period IRR Cost of Capital NPV of this project Proposal 1 Proposal 2 BIU lit li Merge & Center Copy Format Painter Clipboard Font Alignment D E F H B G Year Year 2 Year Year Year 5 Yout Year Information Given Sales Current Capacity of cases INCREMENTAL Sales Expansion of cases A price parce Dots of new equipment Salle Other uptrend costs Gros Map Incremental Selling General and intrative Expenses Net Working Capital (NOW of revenue of share outstanding Dividend per share Dividend powth rate Share price Year Year Year Years Year 3 Year 4 Year 2 INCREMENTAL O forma Income Statement (in thouse Ravenue Cost of Goods Sold Gross Profit Seine Cheral and Administrative Expenses Depreciation Other operatin expenses EDIT Income Tax incremental Emines Vedo Vers 1 Year 2 Year a Year 5 Year 5 Net Operating Working Capital forecast (in thousands Now Change in NOWC Year o Yet Yhar 2 Year Voor 4 Year 5 Years Incremental Free Cash Flows in thousands of $) Incremental Earnings Plus Deprecation Minus Capital Expenditure Minus Ohang in NOWO FCF Payback Period IRR Cost of Capital NPV of this project Proposal 1 Proposal 2 14%20IntegrativeCase.pdf he RNMKRS Netflix My Drive - Google... Chegg Study Cheg. in Linkedin Candidate Portal D... Nanovo Inc., is a manufacturer of low-cost micro batteries for use in a wide variety of compact electronic devices such as children's toys, wireless transmitters, and sensors. The growth in the use of these devices has steadily increased, leading to an ever greater demand for Nanovo's products. Nanovo has responded to this increase in demand by expanding its production capacity, more than doubling the firm's size over the last decade. Despite this growth, however, Nanovo does not have sufficient capacity to meet the current demand for its ultra-long life, low-voltage batteries. You have been asked to evaluate two proposals to expand one of Nanovo's existing plants and make a recommendation The current plant has a capacity of 250,000 cases per month . Proposal 1 The first proposal is for a major expansion that would double the plant's current capacity to 500.000 cases per month. After talking with the firm's design engineers, sales managers, and plant operators, you have prepared the following estimates: Expanding the plant will require the purchase of $3.6 million in new equipment and entail up-front design and engineering expenses of $3.9 million. These costs will be paid immediately (at Year O) when the expansion begins Installing the new equipment and redesigning the plant to accommodate the higher capacity will require shutting down the plant for nine months. During that time, the plant's production will cease. After the expansion is finished, the plant will operate at double its original capacity. (The production shutdown will occur in Year 1.) Marketing and seling the additional volume will lead to $1 million per year in additional sales, marketing, and administrative costs. These costs will begin in the first year (even while the plant is under construction and shut down). Proposal 2 The engineers have put forth a second proposal for a minor expansion that will increase the firm's capacity by only 60%. to 400,000 cases per month. While the capacity is smaller, such an expansion would be cheaper and less disruptive: The smaller expansion will require only $2.4 million in new equipment, and $1.5 million in design and engineering expenses. The existing plant will need to be shut down for only four months Sales, marketing, and administrative costs will only increase by $500,000. Case.pdf X Netflix NEX 14%20IntegrativeCase.pdf mRNMKRS My Drive. Google Chegg Study Cheg. in Linkedin Candidate Portal Nanovo believes that with or without any expansion, the technology used at the plant will be obsolete arter six years and will have no salvage value, and the plant itself will need to be completely overhauled at that time. You also have the following additional general information: With or without either proposed expansion, Nanovo will be able to sell all it can produce at an average wholesale price of $80 per case. This price is not expected to change during the next six years. Nanovo has a gross profit margin of 55% on these batteries. Nanovo's average net working capital at the end of each year will equal 15% of the projected annual revenue next year. Nanovo pays a 40% corporate tax rate. While all design and engineering costs are immediately deductible as operating expenses, all capital expenditures will be straight-line depreciated for tax purposes over the subsequent six years. Management believes the risk of the expansion is similar to the risk of Nanovo's existing projects, and because Nanovo is all equity financed, the risk of the expansion is also similar to the risk of Nanovo stock. You have the following additional information about the stock: Nanovo has no debt and has 2 million shares outstanding. The firm's current share price is $75 per share. Analysts are expecting Nanovo to pay a $3 dividend at the end of this year (e. D1-$3), and to raise its dividend at an average rate of 8% per year in the future. Based on this information, you have been tasked with preparing expansion recommendations for Nanova. . Case Questions 1. Determine the annual incremental free cash flow associated with each expansion proposal relative to the status quo (no expansion). 2. Compute the IRR and payback period of each expansion proposal. Which plan has a higher IRR? Which has a shorter payback period? 3. Estimate Nanovo's equity cost of capital. Use it to determine the NPV associated with each expansion proposal. Which plan has a higher NPV? 4. Should Nanovo expand the plant? If so, which proposal should Nanovo adopt? Explain 5. If the Nanovo's cost of capital is 16%, how would you choose between the two proposals? Explain 6. Create the NPV profiles for both projects. The NPV of which of the two proposals is more sensitive to errors in the estimation of cost of capital? Explain Complete the calculations necessary for answering 1-6 in Excel. Use the templated provided. 7. Suppose Nanovo decides to do the major expansion. If investors are not expecting this expansion, and if they agree with the forecasts above, how will the stock price change when the expansion is announced? Save OM Home Insert Draw Page Layout Formulas Data Review View Developer Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected Vi XV A D Year 1 E Year 2 F Year 3 Year Yoar 4 Year 6 Year 5 B Information Given es at Current Capacity (# of cases) INCREMENTAL Sales after Expansion of a Average price percase Cost ot new equipment Salvage value Other upfrond costs Gross Marga Incremental Selling General, and Adminstrative Expenses Net Worlung Capital (NOWC) as a % of revenue Taxate of shares outstanding Dividend per share Dividend Browth rate Share price Year 1 Year 2 Year 3 Yoar 4 Yoar 5 Yoar 6 INCREMENTAL proforma Income Statement in thousand Year Revenue Cost of Goods Sold Grous Profit Senin General, and Administrative Expenses Depreciation Other Operating expenses Income Tax incremental Earnings Year o Year 1 Year 2 Yaara Yoar 4 Year 5 Yar 6 Not Operating Working Capital forecast (in thousands of NOWC Change in NOWC Your Year 1 Year 2 Your Year 4 Yoar 5 Year o Incremental Free Cash Flows in thousands of 5) Incremental Earnings Plus Dopeoication Minus Capital Expenditure Mnus Change in NOWC HCF Payback Period IRR Cost of Capital NPV of this project Proposal 1 Proposal 2 BIU lit li Merge & Center Copy Format Painter Clipboard Font Alignment D E F H B G Year Year 2 Year Year Year 5 Yout Year Information Given Sales Current Capacity of cases INCREMENTAL Sales Expansion of cases A price parce Dots of new equipment Salle Other uptrend costs Gros Map Incremental Selling General and intrative Expenses Net Working Capital (NOW of revenue of share outstanding Dividend per share Dividend powth rate Share price Year Year Year Years Year 3 Year 4 Year 2 INCREMENTAL O forma Income Statement (in thouse Ravenue Cost of Goods Sold Gross Profit Seine Cheral and Administrative Expenses Depreciation Other operatin expenses EDIT Income Tax incremental Emines Vedo Vers 1 Year 2 Year a Year 5 Year 5 Net Operating Working Capital forecast (in thousands Now Change in NOWC Year o Yet Yhar 2 Year Voor 4 Year 5 Years Incremental Free Cash Flows in thousands of $) Incremental Earnings Plus Deprecation Minus Capital Expenditure Minus Ohang in NOWO FCF Payback Period IRR Cost of Capital NPV of this project Proposal 1 Proposal 2