$4,500,000 $750,000 Pancho Republic Electronics - Capital Budgeting Spreadsheet Equipment $20,500,000 Pretax salvage value R&D Marketing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
$4,500,000 $750,000 Pancho Republic Electronics - Capital Budgeting Spreadsheet Equipment $20,500,000 Pretax salvage value R&D Marketing study $200,000 Year Year Year? Year 4 Sales (units) 84000 99000 130000 110000 Year 5 90000 Sales of old PDA 80000 60000 Lost sales 15000 15000 Depreciation rate 14.29% 24.49% 17.49% 12.49% 8.93% Price $380 VC $165 FC $4,900,000 Price of old PDA Price reduction of old PDA $310 $55 VC of old PDA $120 Tax rate 21% NWC percentage 20% Required return 12% Sales Year Year? Year? Year 4 Year 5 New Sales Lost sales Lost revenue Net sales VC New Lost sales Total VC Sales VC Fixed costs Dep EBT Tax NI +Dep OCF NWC Beg End NWC CF Net CF Salvage BV of equipment Taxes Salvage CF Time 0 Cash flow 1 2 5 Show all dormulas and calculations (20 Pts.] Profitability index (20 Pts.) IRR (20 Pts.) NPV Pancho Republic Electronics - Capital Budgeting Pancho Republic Electronics is a midsized electronics manufacturer founded over 70 years ago that originally repaired radios, but it expanded and now is a reputed manufactures of various electronic items including smart phones, and is located in Key West, Florida. The company is presided by Shelley Couts, who inherited the company. you were hired as a recent MBA in the finance Pancho Republic can manufacture a new smart phone for $165 each in variable costs. Fixed costs are expected to run $4.9 million per year. The estimated sales are 84,000, 99,000, 130,000, 110,000, and 90,000 per year for the next 5 years, respectively. The price per unit will be $380. The necessary equipment can be purchased at $20.5 million and will be depreciated on a secevn-year MACRS schedule (14.29%, 24.49%, 17.49%, 12.49%, 8.93%, 8.92%, 8.93%, and 4.46%). It is believed that the market value of the equipment in 5 years will be $4.5 million. Net working capital for the new smart phone project will be 20% of each year sales with the timing of the cash flows's sales (i.e., at the end of each year). No initial working capital is incurred. Pancho Republic already manufactures a smart phone model, which it intends to stop manufacturing in two years. If it does not stop, it will sell 80,000 and 60,000 units at $310 each, respectively over the next two years. The variable cost per unit of the existing model is $120 and fixed costs are $1,800,000 per year. With the introduction of the new smart phone, sales of the existing model will drop by 15,000 units per year and the unit price will have to be lowered to $255. Variable costs and The corporate tax rate for Pancho Electronics is 21 percent, and its required rate of return is 12%. Shelley has asked you to prepare a report that answers the following questions. a. (20 Points) What is the profitability index of the project? b. C. (20 Points) What is the IRR of the project? (20 Points) What is the NPV of the project? $4,500,000 $750,000 Pancho Republic Electronics - Capital Budgeting Spreadsheet Equipment $20,500,000 Pretax salvage value R&D Marketing study $200,000 Year Year Year? Year 4 Sales (units) 84000 99000 130000 110000 Year 5 90000 Sales of old PDA 80000 60000 Lost sales 15000 15000 Depreciation rate 14.29% 24.49% 17.49% 12.49% 8.93% Price $380 VC $165 FC $4,900,000 Price of old PDA Price reduction of old PDA $310 $55 VC of old PDA $120 Tax rate 21% NWC percentage 20% Required return 12% Sales Year Year? Year? Year 4 Year 5 New Sales Lost sales Lost revenue Net sales VC New Lost sales Total VC Sales VC Fixed costs Dep EBT Tax NI +Dep OCF NWC Beg End NWC CF Net CF Salvage BV of equipment Taxes Salvage CF Time 0 Cash flow 1 2 5 Show all dormulas and calculations (20 Pts.] Profitability index (20 Pts.) IRR (20 Pts.) NPV Pancho Republic Electronics - Capital Budgeting Pancho Republic Electronics is a midsized electronics manufacturer founded over 70 years ago that originally repaired radios, but it expanded and now is a reputed manufactures of various electronic items including smart phones, and is located in Key West, Florida. The company is presided by Shelley Couts, who inherited the company. you were hired as a recent MBA in the finance Pancho Republic can manufacture a new smart phone for $165 each in variable costs. Fixed costs are expected to run $4.9 million per year. The estimated sales are 84,000, 99,000, 130,000, 110,000, and 90,000 per year for the next 5 years, respectively. The price per unit will be $380. The necessary equipment can be purchased at $20.5 million and will be depreciated on a secevn-year MACRS schedule (14.29%, 24.49%, 17.49%, 12.49%, 8.93%, 8.92%, 8.93%, and 4.46%). It is believed that the market value of the equipment in 5 years will be $4.5 million. Net working capital for the new smart phone project will be 20% of each year sales with the timing of the cash flows's sales (i.e., at the end of each year). No initial working capital is incurred. Pancho Republic already manufactures a smart phone model, which it intends to stop manufacturing in two years. If it does not stop, it will sell 80,000 and 60,000 units at $310 each, respectively over the next two years. The variable cost per unit of the existing model is $120 and fixed costs are $1,800,000 per year. With the introduction of the new smart phone, sales of the existing model will drop by 15,000 units per year and the unit price will have to be lowered to $255. Variable costs and The corporate tax rate for Pancho Electronics is 21 percent, and its required rate of return is 12%. Shelley has asked you to prepare a report that answers the following questions. a. (20 Points) What is the profitability index of the project? b. C. (20 Points) What is the IRR of the project? (20 Points) What is the NPV of the project?
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Revonce Company sells merchandise on a consignment basis to dealers .The selling price of the merchandise averages 25% above cost. The dealer is paid a 10% commission of the sales price for all sales...
-
On October 31, 2015, Damon Companys general ledger shows a checking account balance of $8,397. The companys cash receipts for the month total $74,320, of which $71,295 has been deposited in the bank....
-
Look at Figure. What kind of information would you need to have to be able to put together a table like Figure to present to the steering committee? How much of that information is objective?...
-
Which of the following is most likely to be an example of a natural, executable workload model? a. A kernel program b. An instruction mix c. A benchmark d. A synthetic job
-
What is meant by the term self-supporting growth rate? How is this rate related to the AFN equation, and how can that equation be used to calculate the self-supporting growth rate?
-
dr t . used an example of mislabeled drugs at 6 per 2 0 0 , 0 0 0 . this is an example of defects per million, TQM , Lean, Six Sigma
-
Consider the following circuit. P Q R AND OR NOT AND Write the Boolean expression corresponding to the circuit. 12. (5 pts) Construct a truth table for the formula ~ PA(P-Q). 13. (5 pts) Show that...
-
In this board you are to address the build-up of intelligence collection operations against suspected Taliban and AQ targets in the area around Gardez and Khost, Afghanistan. The object is to allow...
-
Many years ago, many politicians argued that because Microsoft Windows was installed on 90% of personal computers worldwide, it had a monopoly on the PC Operating Systems market. Does that argument...
-
Consider the indefinite integral, 7(x): 1(x) = = x+4x= x+4x-17 -dx = F(x)+c x-3 where F(x) is the primitive and c is the integration constant. If1(k) =0 where k = 4.6, find the value of c. Give your...
-
What are the primary advantages of a mentoring relationship as part of a new employee's orientation? Explain in details.
-
Positive" and "normative" economics is the study of "what is" and "what should be," respectively. Describe the differences between the two concepts. Consider the following statement: Inequality is...
-
Write a short note on COPYRIGHT?
-
d. The characteristic equation of a control system is given by s+2s+8s+12s+20s+16+16=0. Determine the number of the roots of the equation which lie on the imaginary axis of s-plane
Study smarter with the SolutionInn App