I included all my work prior to the last section that I need help with in case you need it, but I'm only wondering what the Payback period, PI, IRR, NPV would be! Any help would be greatly appreciated!

Hoosier Technology, Inc. is a producer of digital rearview mirrors. Its current line of mirrors are selling excellently. However, in order to cope with the foreseeable competition from other similar products, HT spent $5,900,000 to develop a new line of digital full display rearview mirrors (new model development cost). The new rearview mirror includes a video screen placed under the mirror's glass. The video recorder can help protect the driver-user after a crash and keep track of what the passengers do inside the vehicle. The recorder can be used to replace the clunky dashcam that usually blocks at least partial forward visibility. As the system is built into the mirror housing, the new mirror model looks just like any other rearview mirror. The system allows its user to download files from the mirror-integrated DVR simply through a smartphone app. The recording function of the system is able to capture various traffic incidents kfrom road scenes to wrecks) and shoot videos ahead of and behind the user's vehicle. It will provide helpful evidence on who has actually caused a crash in case the driver-user is not at fault but blamed for causing the crash. The system is compatible with Bluetooth and Wi-Fi. It also comes with audio recording capability that can be triggered by an internal shock sensor. The sensor will enable the system to automatically start recording if someone backs into the user's vehicle while it is parked. As such, the perpetrator's license plate number can be taken for possible charges subsequently filed. The model is expected to be globally available on more than 100 vehicle models made by 10 different automobile manufacturers. The company had also spent a further $1,300,000 to study the marketability of this new line of mirror model (marketability studying cost). HT is able to produce the new digital full display rearview mirrors at a variable cost of $70 each. The total fixed costs for the operation are expected to be $9,000,000 per year. HT expects to sell 3,800,000 units, 4,500,000 units, 2,800,000 units, 1,800,000 units and 1,200,000 units of the new mirror model per year over the next five years respectively. The new mirrors will be selling at a price of $120 each. To launch this new line of production, HT needs to invest $32,000,000 in equipment which will be depreciated on a seven-year MACRS schedule. The value of the used equipment is expected to be worth $4,200,000 as at the end of the 5 year project life. HT is planning to stop producing the existing mirror model entirely in two years. Should HT not introduce the new mirrors, sales per year of the existing mirror model will be 1,800,000 units and 1,300,000 units for the next two years respectively. The existing model can be produced at variable costs of $50 each and total fixed costs of $7,500,000 per year. The existing mirror model is selling for $100 per mirror. If HT produces the new mirror model, sales of existing model will be eroded by 1,080,000 units for next year and 1,105,000 units for the year after next. In addition, to promote sales of the existing model alongside with the new mirror model, HT has to reduce the price of the existing model to $75 each. Net working capital for the new mirror project will be 20 percent of sales and will vary with the occurrence of the cash flows. As such, there will be no initial NWC required. The first change in NWC is expected to occur in year 1 according to the sales of the year. HT is currently in the tax bracket of 35 percent and it requires a 20 percent returns on all of its projects. The firm also requires a payback of 4 years for all projects. You have just been hired by HT as a financial consultant to advise them on this new digital full display rearview mirror project. You are expected to provide answers to the following questions to their management by their next meeting which is scheduled sometime next month. What is/are the sunk cost(s) for this new digital full display rearview mirror project? Briefly explain. You have to tell what sunk cost is and the amount of the total sunk cost(s). In addition, you have to advise HT on how to handle such cost(s). What are the cash flows of the project for each year? What is the payback period of the project? What is the Pi (profitability index) of the project? What is the IRR (internal rate of return) of the project? What is the NPV (net present value) of the project? Should the project be accepted based on Payback, PI, IRR and NPV? Briefly explain. Year 1 Variable costs = 3,800,000 $ =$ 212,000,000.00 70 1,080,000 $ 50 Year 2 Variable costs = 4,500,000 $ =$ 259,750,000.00 70 1,105,000 x $ 50 >> Year 3 Variable costs =$ 196,000,000.00 Year 4 Variable costs =$ 126,000,000.00 Year 5 Variable costs = 84,000,000.00 Depreciation Estimation: Use the formula stated below to calculate the depreciation expenses. Depreciation of Yeart = Cost of equipment MACRS percentage for Yeart [For all MACRS percentages in this part, enter as a decimal number with 4 decimal places.] Depreciation of Year 1 = $ 32,000,000.00 .1429 =$ 4,572,800.00 Depreciation of Year 2 = $ 32,000,000.00 x 2449 =$ 7,836,800.00 Depreciation of Year 3 = $ 32,000,000.00 x .1749 =$ 5,596,800.00 Depreciation of Year 4 = $ 32,000,000.00 .1249 =$ 3,996,800.00 Depreciation of Year 5 = $ 32,000,000.00 .0893 =$ 2,857,600.00 Net Working Capital Estimation: Use the formula stated below to calculate the net working capital requirements. NWC for Yeart = NWC Required Percentage x Net sales of Yeart [For the NWC required percentage in this part , enter as a decimal number with 2 decimal places.] NWC for Year 1 = 20 * $ 330,000,000.00 =$ 66,000,000.00 NWC for Year 2 = .20 $ 424,625,000.00 =$ 84,925,000.00 NWC for Year 3 .20 $ 336,000,000.00 =$ 67,200,000.00 NWC for Year 4 = 20 * $ 216,000,000.00 =$ 43,200,000.00 NWC for Year 5 .00 ollo = > = $ CASH FLOW ESTIMATION: Complete the following table below. Year 1 Year 2 Year 3 Year 4 Year 5 $ $ $ $ Sales | 330,000,000.00 424,625,000.00 336,000,000.00 216,000,000.00 144,000,000.00 VC $ $ $ $ 212,000,000.00 259,750,000.00 196,000,000.00 126,000,000.00 84,000,000.00 Fixed $ 9,000,000.00 $ 9,000,000.00 $ 9,000,000.00 $ 9,000,000.00 $ 9,000,000.00 costs Dep $ 4,572,800.00 $ 7,836,800.00 $ 5,596,800.00 $ 3,996,800.00 $ 2,857,600.00 la la la [ ] $ $ $ $ EBT 104,427,200.00 148,038,200.00 125,403,200.00 77,003,200.00 48,142,400.00 > $ $ Taxes 36,549,520.00 51,813,370.00 $ 43,891,120.00 $ 26,951,120.00 16,849,840.00 35%) 1 $ $ $ NI $ 67,877,680.00 96,224,830.00 81,512,080.00 50,052,080.00 31,292,560.00 $ 4,572,800.00 $ 7,836,800.00 $ 5,596,800.00 $ 3,996,800.00 $ 2,857,600.00 Dep OCF $ 72,450,480 $ 104,061,630 $ 54,048,880 $ 87,108,880 $ 34,150,160 INWC Beg $ .00 $ 66,000,000.00 84,925,000.00 67,200,000.00 43,200,000.00 $ -End 66,000,000.00 84,925,000.00 67,200,000.00 $ 43,200,000.00 $ .00 $ INWC -66,000,000.00 $ (18,925,000) CF 24,000,000 $ 43,200,000.00 $ 17,725,000 NCF $ 6,450,480 $ 85,136,630 $ 104,833,880 $ 78,048,880 $ 77,350,160 Accumulated depreciation of equipment = $ 24,860,800 Book value of equipment = $ 7,139,200 Market value of equipment = $ 4,200,000.00 Tax associated with sale of equipment = $ -1,028,720 (Enter as a positive number if tax liability or as a negative number if tax credit.] CF on sale of equipment = $ 5,228,720 (Do not round your calculations. Round your answers below to the number of decimal places specified.) Evaluation Method Payback PI (Profitability Index) RR (Internal Rate of Return) NPV (Net Present Value) years (2 decimal places) (2 decimal places) % (2 decimal places) (whole number with no decimal place)

Question

I included all my work prior to the last section that I need help with in case you need it, but I'm only wondering what the Payback period, PI, IRR, NPV would be! Any help would be greatly appreciated!

image text in transcribed

Hoosier Technology, Inc. is a producer of digital rearview mirrors. Its current line of mirrors are selling excellently. However, in order to cope with the foreseeable competition from other similar products, HT spent $5,900,000 to develop a new line of digital full display rearview mirrors (new model development cost). The new rearview mirror includes a video screen placed under the mirror's glass. The video recorder can help protect the driver-user after a crash and keep track of what the passengers do inside the vehicle. The recorder can be used to replace the clunky dashcam that usually blocks at least partial forward visibility. As the system is built into the mirror housing, the new mirror model looks just like any other rearview mirror. The system allows its user to download files from the mirror-integrated DVR simply through a smartphone app. The recording function of the system is able to capture various traffic incidents kfrom road scenes to wrecks) and shoot videos ahead of and behind the user's vehicle. It will provide helpful evidence on who has actually caused a crash in case the driver-user is not at fault but blamed for causing the crash. The system is compatible with Bluetooth and Wi-Fi. It also comes with audio recording capability that can be triggered by an internal shock sensor. The sensor will enable the system to automatically start recording if someone backs into the user's vehicle while it is parked. As such, the perpetrator's license plate number can be taken for possible charges subsequently filed. The model is expected to be globally available on more than 100 vehicle models made by 10 different automobile manufacturers. The company had also spent a further $1,300,000 to study the marketability of this new line of mirror model (marketability studying cost). HT is able to produce the new digital full display rearview mirrors at a variable cost of $70 each. The total fixed costs for the operation are expected to be $9,000,000 per year. HT expects to sell 3,800,000 units, 4,500,000 units, 2,800,000 units, 1,800,000 units and 1,200,000 units of the new mirror model per year over the next five years respectively. The new mirrors will be selling at a price of $120 each. To launch this new line of production, HT needs to invest $32,000,000 in equipment which will be depreciated on a seven-year MACRS schedule. The value of the used equipment is expected to be worth $4,200,000 as at the end of the 5 year project life. HT is planning to stop producing the existing mirror model entirely in two years. Should HT not introduce the new mirrors, sales per year of the existing mirror model will be 1,800,000 units and 1,300,000 units for the next two years respectively. The existing model can be produced at variable costs of $50 each and total fixed costs of $7,500,000 per year. The existing mirror model is selling for $100 per mirror. If HT produces the new mirror model, sales of existing model will be eroded by 1,080,000 units for next year and 1,105,000 units for the year after next. In addition, to promote sales of the existing model alongside with the new mirror model, HT has to reduce the price of the existing model to $75 each. Net working capital for the new mirror project will be 20 percent of sales and will vary with the occurrence of the cash flows. As such, there will be no initial NWC required. The first change in NWC is expected to occur in year 1 according to the sales of the year. HT is currently in the tax bracket of 35 percent and it requires a 20 percent returns on all of its projects. The firm also requires a payback of 4 years for all projects. You have just been hired by HT as a financial consultant to advise them on this new digital full display rearview mirror project. You are expected to provide answers to the following questions to their management by their next meeting which is scheduled sometime next month. What is/are the sunk cost(s) for this new digital full display rearview mirror project? Briefly explain. You have to tell what sunk cost is and the amount of the total sunk cost(s). In addition, you have to advise HT on how to handle such cost(s). What are the cash flows of the project for each year? What is the payback period of the project? What is the Pi (profitability index) of the project? What is the IRR (internal rate of return) of the project? What is the NPV (net present value) of the project? Should the project be accepted based on Payback, PI, IRR and NPV? Briefly explain. Year 1 Variable costs = 3,800,000 $ =$ 212,000,000.00 70 1,080,000 $ 50 Year 2 Variable costs = 4,500,000 $ =$ 259,750,000.00 70 1,105,000 x $ 50 >> Year 3 Variable costs =$ 196,000,000.00 Year 4 Variable costs =$ 126,000,000.00 Year 5 Variable costs = 84,000,000.00 Depreciation Estimation: Use the formula stated below to calculate the depreciation expenses. Depreciation of Yeart = Cost of equipment MACRS percentage for Yeart [For all MACRS percentages in this part, enter as a decimal number with 4 decimal places.] Depreciation of Year 1 = $ 32,000,000.00 .1429 =$ 4,572,800.00 Depreciation of Year 2 = $ 32,000,000.00 x 2449 =$ 7,836,800.00 Depreciation of Year 3 = $ 32,000,000.00 x .1749 =$ 5,596,800.00 Depreciation of Year 4 = $ 32,000,000.00 .1249 =$ 3,996,800.00 Depreciation of Year 5 = $ 32,000,000.00 .0893 =$ 2,857,600.00 Net Working Capital Estimation: Use the formula stated below to calculate the net working capital requirements. NWC for Yeart = NWC Required Percentage x Net sales of Yeart [For the NWC required percentage in this part , enter as a decimal number with 2 decimal places.] NWC for Year 1 = 20 * $ 330,000,000.00 =$ 66,000,000.00 NWC for Year 2 = .20 $ 424,625,000.00 =$ 84,925,000.00 NWC for Year 3 .20 $ 336,000,000.00 =$ 67,200,000.00 NWC for Year 4 = 20 * $ 216,000,000.00 =$ 43,200,000.00 NWC for Year 5 .00 ollo = > = $ CASH FLOW ESTIMATION: Complete the following table below. Year 1 Year 2 Year 3 Year 4 Year 5 $ $ $ $ Sales | 330,000,000.00 424,625,000.00 336,000,000.00 216,000,000.00 144,000,000.00 VC $ $ $ $ 212,000,000.00 259,750,000.00 196,000,000.00 126,000,000.00 84,000,000.00 Fixed $ 9,000,000.00 $ 9,000,000.00 $ 9,000,000.00 $ 9,000,000.00 $ 9,000,000.00 costs Dep $ 4,572,800.00 $ 7,836,800.00 $ 5,596,800.00 $ 3,996,800.00 $ 2,857,600.00 la la la [ ] $ $ $ $ EBT 104,427,200.00 148,038,200.00 125,403,200.00 77,003,200.00 48,142,400.00 > $ $ Taxes 36,549,520.00 51,813,370.00 $ 43,891,120.00 $ 26,951,120.00 16,849,840.00 35%) 1 $ $ $ NI $ 67,877,680.00 96,224,830.00 81,512,080.00 50,052,080.00 31,292,560.00 $ 4,572,800.00 $ 7,836,800.00 $ 5,596,800.00 $ 3,996,800.00 $ 2,857,600.00 Dep OCF $ 72,450,480 $ 104,061,630 $ 54,048,880 $ 87,108,880 $ 34,150,160 INWC Beg $ .00 $ 66,000,000.00 84,925,000.00 67,200,000.00 43,200,000.00 $ -End 66,000,000.00 84,925,000.00 67,200,000.00 $ 43,200,000.00 $ .00 $ INWC -66,000,000.00 $ (18,925,000) CF 24,000,000 $ 43,200,000.00 $ 17,725,000 NCF $ 6,450,480 $ 85,136,630 $ 104,833,880 $ 78,048,880 $ 77,350,160 Accumulated depreciation of equipment = $ 24,860,800 Book value of equipment = $ 7,139,200 Market value of equipment = $ 4,200,000.00 Tax associated with sale of equipment = $ -1,028,720 (Enter as a positive number if tax liability or as a negative number if tax credit.] CF on sale of equipment = $ 5,228,720 (Do not round your calculations. Round your answers below to the number of decimal places specified.) Evaluation Method Payback PI (Profitability Index) RR (Internal Rate of Return) NPV (Net Present Value) years (2 decimal places) (2 decimal places) % (2 decimal places) (whole number with no decimal place)