How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Annie Kavitha Your Own Question
Annie Kavitha
Annie Kavitha, Master's Degree
Category: Business and Finance Homework
Satisfied Customers: 1024
Experience:  17 years of teaching experience and 5 years of online tutoring experience.
4245996
Type Your Business and Finance Homework Question Here...
Annie Kavitha is online now
A new question is answered every 9 seconds

finance

Resolved Question:

AB 217 Electronics is a midsized electronics manufacturer located in Melbourne, Florida. The company president is Sherry Jones. When it was founded over 70 years ago, the company originally repaired radios and other household appliances. Over the years, the company expanded into manufacturing and is now a reputable manufacturer of various electronic items. XXXXX XXXXX has been hired by the company's finance department. One of the major revenue-producing items manufactured by AB 217 is a personal digital assistant (PDA). AB 217 currently has one PDA model on the market, and sales have been excellent. The PDA is a unique item in that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly, and the current PDA has limited features in comparison with newer models. AB 217 developed a prototype for a new PDA that has all the features of the existing PDA but adds new features such as cell phone capability. The company has performed a marketing study to determine the expected sales figures for the new PDA. AB 217 can manufacture the new PDA for $200 each in variable costs. Fixed costs for the operation are estimated to run $4.5 million per year. The estimated sales volume is 70,000, 80,000, 100,000, 85,000, and 75,000 per each year for the next five years, respectively. The unit price of the new PDA will be $340. The necessary equipment can be purchased for $16.5 million and will be depreciated on a 5 year straight-line schedule. Net working capital investment for the PDAs will be $6,000,000 this year. Of course NWC will be recovered at the projects end. AB 217 has a 35 percent corporate tax rate. AB 217’s capital structure is 40% debt with an after-tax cost of 8% and 60% equity costing 16%, Sherry has asked Doug to prepare a report that answers the following questions: 1. What is AB 217’s WACC, which will be used as the required rate of return for this project? 2. What is the IRR of the project? 3. What is the NPV of the project, based on the WACC (required rate of return)? If you were Doug, how would you answer the questions?


 






































































































































































































































































































































































































































































































































































 



 



 



 



 



 



 



Capital Structure



 



Weight (W)



 



Yield (r)



 



 



 



 



 



Debt (d)



 



0.40



 



8.0



 



 



 



 



 



Common Equity (s)



 



0.60



 



16.0



 



 



 



 



 



Weight Sum



 



1.00



 



 



 



 



 



 



Tax Rate (T)



 



0.35



 



 



 



 



 



 



 



 



 



 



 



 



 



1) What is AB 217’s WACC, which will be used as the required rate of return for this project?



 



 



 



 



 



 



 



 



 



 



 



 



Debt (d)



 



 



<-------------------------(Wd x rd x (1 – T))



 



 



 



 



Common Equity (s)



 



 



<-------------------------(Ws x rs)



 



 



 



 



WACC (%) =



 



 



<-------------------------Sum of Debt and Common Equity components above = (Wd x rd x (1 – T)) + (Ws x rs)



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



2) W hat is the IRR of the project?



 



 



 



 



 



 



 



 



 



 



 



 



 



 



Price of each PDA



 



$340.00



 



 



 



 



 



 



PDA Fixed Cost



 



$200.00



 



 



 



 



 



 



 



 



 



 



 



 



 



Calculation of Cash Flows



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



Year 0



 



Year 1



 



Year 2



 



Year 3



 



Year 4



 



Year 5



 



Sales(in Units)



 



 



 



 



 



 



 



Sales(in Dollar)



 



 



 



 



 



 



 



Less: Variable Cost



 



 



 



 



 



 



 



Less: Fixed Cost



 



 



 



 



 



 



 



Less: Depreciation



 



 



 



 



 



 



 



Earning Before Tax



 



 



 



 



 



 



 



Less: Taxes



 



 



 



 



 



 



 



Earning After Tax



 



 



 



 



 



 



 



Add: Depreciation



 



 



 



 



 



 



 



Cash Flow from Operations



 



 



 



 



 



 



 



 



 



 



 



 



 



 



Initial Investment



 



-$16,500,000



 



 



 



 



 



 



Investment in Working Capital



 



-$6,000,000



 



 



 



 



 



$6,000,000



 



 



 



 



 



 



 



 



Net Cash Flow



 



 



-$22,500,000



 



 



$0



 



 



$0



 



 



$0



 



 



$0



 



 



$6,000,000



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



Year



 



Cash Flow



 



 



 



 



 



 



0



 



 



 



 



 



 



 



1



 



 



 



 



 



 



 



2



 



 



 



 



 



 



 



3



 



 



 



 



 



 



 



4



 



 



 



 



 



 



 



5



 



 



 



 



 



 



 



IRR =



 



 



#NUM!



 



 



<------------------------- =IRR(B45:B50)



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



3) What is the NPV of the project, based on the WACC (required rate of return)?



 



 



 



 



 



 



 



 



 



 



 



 



WACC from B14 =



 



0



 



 



 



 



 



 



 



 



 



 



 



 



 



Year



 



Cash Flow



 



NPV



 



 



 



 



 



0



 



 



$0.00



 



 



 



 



 



1



 



 



$0.00



 



 



 



 



 



2



 



 



$0.00



 



 



 



 



 



3



 



 



$0.00



 



 



 



 



 



4



 



 



$0.00



 



 



 



 



 



5



 



 



$0.00



 



 



 



 



 



 



NPV =



 



 



$0.00



 



 



 



 



 



 



 



 



 



 



 



 



 



 

Submitted: 5 years ago.
Category: Business and Finance Homework
Expert:  Annie Kavitha replied 5 years ago.

Please upload the template.

Customer: replied 5 years ago.
Expert:  Annie Kavitha replied 5 years ago.
Annie Kavitha and other Business and Finance Homework Specialists are ready to help you