Question: Please fill in blank with the RIGHT answer after you double check the work. Thanks Problem 3: Peggy's Peaches has developed a new product, the

Please fill in blank with the RIGHT answer after you double check the work. Thanks

Please fill in blank with the RIGHT answer after you double checkthe work. Thanks Problem 3: Peggy's Peaches has developed a new product,the Bruiseless Peach, which always stays peachy fresh. Peggy's paid $85,000 to

Problem 3: Peggy's Peaches has developed a new product, the Bruiseless Peach, which always stays peachy fresh. Peggy's paid $85,000 to a marketing firm to survey the bruiseless peach market. The potential sales were estimated at $250,000 per year. New equipment will be necessary to carefully handle the peaches. It cost $200,000 and will have fixed costs of $70,000 per year, and variable costs will be 25% of sales. The new anti-bruise machine will be depreciated straight-line for the four years of it's life and is the only initial cost for the new "Peggy's Peaches, the UnBruised Ones". Peggy's pays 34% tax and has a required return of 8%. Calculate the NPV and IRR. Solution: Enter numbers and formulas to solve this problem. Use the Excel NPV and IRR functions to solve NPV and IRR.. Step 1. Find the Net Income for years 1-4. Depreciation = (Initial cost - Salvage Value)/ years Assume Salvage Value = 0. ==> Net Income Year 1-4 Sales Variable Costs Fixed Costs Depreciation EBIT Taxes Net Income from problem 25% of Sales from problem from H18 EBIT = Sales-costs-dep Taxes = EBIT * tax rate NI = EBIT - taxes = Operating Cash Flows EBIT + Depreciation - Taxes After-Tax Cash Flow After-Tax Cash Flows Years CF 0 Cost of machine as a negative # Equal Cash Flows from cell F133 1 2 3 4 Required Return Net Present Value Internal Rate of Return

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!