FASTTT ASAP ONE HOUR MAX PLZZZ

Can you solve it please YOU HAVE AN HOUR AND HALF WHATEVER IS DONE IS FINE JUST SEND ME?

Book ISBN 9781285432274

Thank you so much

Cost of Equipment Installation Charge Life in Years MACRS Class Riders per Ride Rides per Day Days per Season Year 1 Ticket Price Ticket Price Increase Variable Cost per Rider Annual Fixed Costs Salvage Value $ $ Removal Cost WACC Tax Rate $ Ticket Price Revenue Variable Cost Fixed Cost Depreciation Pre-Tax Cash Flow Taxes Add: Depreciation Terminal Cash Flow After-Tax Cash Flows Net Present Value MIRR IRR Profitabilty Index $ $ $ $ 1,800,000 180,000 6 5 16 150 120 4.00 4% 1.40 275,000 450,000 Provide: The Net Present Value The IRR The Modified IRR and The Profitability Index Hint Sales = riders per ride *rides per day*Days per season MACR percentages provided MACRS Percentage by Class Life 75,000 12% 35% 1 20.00% 2 32.00% 3 19.20% Ocean City Log Flume Operating Cash Flow Statement Year 0 Year 1 Year 2 Year 3 Year 4 $ 4.00 $ 4.16 $ 4.33 $ 4.50 $ 1,151,999 $ 1,198,079 $ 1,246,002 $ 1,295,842 275,000 876,999 $ (1,980,000) 876,999 275,000 923,079 923,079 275,000 971,002 971,002 275,000 1,020,842 1,020,842 per day*Days per season 4 11.52% 5 11.52% Year 5 Year 6 $ 4.68 $ 4.87 $ 1,347,676 $ 1,401,583 275,000 1,072,676 1,072,676 275,000 1,126,583 936,750 2,063,333 6 5.76% You are considering the bonds of Epsilon, Inc., a printer manufacturer. The bonds make semiannual payments and have five y maturity, a coupon rate of 7%, and a redemption value of $1,000. a. Determine the intrinsic value of these bonds assuming that your required rate of return is 10% (use the PV function.) Also the current yield and the yield to call (use the RATE function) if the bonds can be called in four years with a call premium of 2 b. Determine the percentage change in price if market rates decline by 1%. Determine the actual relative change in bond pric the intrinsic values for each rate. Compare this result with those obtained using the formulas with the modified duration only the modified duration and convexity together. c. Determine the durration and modified duration with the Excel Functions Redemption Value Coupon Rate Frequency Maturity (Years) Required Return Call Premium % Years to first call $1,000.00 7.00% 2 5 10.00% 2.00% 4 Value Current Yield Yield to Call Settlement Date Maturity Date Call Date Duration Modified Duration 1/1/2012 1/1/2017 1/1/2016 iannual payments and have five years to 10% (use the PV function.) Also determine ur years with a call premium of 2%. ctual relative change in bond prices using s with the modified duration only and with Reproduce The Given Graph with the given information Period Dividends Pres Value 1 $1.00 $0.87 2 $1.06 $1.67 3 $1.12 $2.41 4 $1.19 $3.09 5 $1.26 $3.72 6 $1.34 $4.30 7 $1.42 $4.83 8 $1.50 $5.32 9 $1.59 $5.77 10 $1.69 $6.19 11 $1.79 $6.58 12 $1.90 $6.93 13 $2.01 $7.26 14 $2.13 $7.56 15 $2.26 $7.84 $2.40 $8.09 16 $2.54 $8.33 17 $2.69 $8.55 18 $2.85 $8.75 19 $3.03 $8.93 20 $3.21 $9.10 21 $3.40 $9.26 22 $3.60 $9.41 23 $3.82 $9.54 24 $4.05 $9.66 25 $4.29 $9.78 26 $4.55 $9.88 27 $4.82 $9.98 28 $5.11 $10.07 29 $5.42 $10.15 30 $5.74 $10.22 31 $6.09 $10.29 32 $6.45 $10.36 33 12.33 12.33 12.33 12.33 12.33 12.33 12.33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 $6.84 $7.25 $7.69 $8.15 $8.64 $9.15 $9.70 $10.29 $10.90 $11.56 $12.25 $12.99 $13.76 $14.59 $15.47 $16.39 $17.38 $18.42 $19.53 $20.70 $21.94 $23.26 $24.65 $26.13 $27.70 $29.36 $31.12 $32.99 $34.97 $37.06 $39.29 $41.65 $44.14 $46.79 $49.60 $52.58 $55.73 $59.08 $62.62 $66.38 $10.42 $10.47 $10.52 $10.57 $10.61 $10.65 $10.68 $10.72 $10.75 $10.78 $10.80 $10.83 $10.85 $10.87 $10.89 $10.91 $10.92 $10.94 $10.95 $10.96 $10.97 $10.99 $11.00 $11.00 $11.01 $11.02 $11.03 $11.03 $11.04 $11.05 $11.05 $11.06 $11.06 $11.06 $11.07 $11.07 $11.07 $11.08 $11.08 $11.08 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 $70.36 $74.58 $79.06 $83.80 $88.83 $94.16 $99.81 $105.80 $112.14 $118.87 $126.00 $133.57 $141.58 $150.07 $159.08 $168.62 $178.74 $189.46 $200.83 $212.88 $225.66 $239.19 $253.55 $268.76 $284.88 $301.98 $320.10 $11.08 $11.09 $11.09 $11.09 $11.09 $11.09 $11.09 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.11 $11.11 $11.11 $11.11 $11.11 $11.11 $11.11 $11.11 Pizza Deliveries, Replacement Analysis Utilize the Scenario Function Price Shipping and Install Original Life Current Life Original Salvage Value Current Salvage Value Book Value Increase in Raw Materials Depreciation Salaries Maintenance Defects Marginal Tax Rate Required Return Cash Flows Initial Outlay Annual After-Tax Savings Depreciation Tax Benefit Total ATCF Terminal Cash Flow Net Present Value (NPV) Old Truck Drones Difference 40,000 100,000 0 6,000 10 5 5 5 0 15,000 22,000 0 20,000 0 4,000 35,000 6,000 4,000 34.00% 15.00% -87,680 23,760 4,828 28,588 18,000 17,100.59 106,000 3,000 18,200 6,000 3,000 Period 0 1 2 3 4 5 Utilizing the Scenario function , what is the NPV of this replacement analysis under the diferent Secnarios? Best Case Expected Case Worst Case Three Possible Scenarios -14,200 35,000 0 1,000 Cash Flows -87,680 28,588 28,588 28,588 28,588 46,588 Best Case Expected Case Worst Case 2000 5000 8000 Maintenanc 1000 2000 5000 Defects