Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I will need to see your calculations (all work);just answers wont work. MUST Do on excel Chapter 4 - Problems 5, 11, 13, 15, &19
I will need to see your calculations (all work);just answers wont work. MUST Do on excel
Chapter 4 - Problems 5, 11, 13, 15, &19 (Pages 119-120)
Chapter 5 - Problems 2, 5, 10, 12, & 20 (Pages 155-157)
Chapter 6 - Problems 3, 5, & 7
pages attached
Book name essentials of corporate finace
Scanned by CamScanner Scanned by CamScanner Scanned by CamScanner Scanned by CamScanner Scanned by CamScanner Scanned by CamScanner Chapter 4 5 Present value years 195 2105 47800 38650 17.394 7.515 16.954 9.822 11 Fv = Nper Rate Calculating the PV using excel function PV = 1000000 80 7.25% $ 13 PV = FV = Nper = 150 1620000 119 Caclualting rate using RATE formula Rate = 8.12% Calculating the FV PV = Rate Nper = FV = 3,700.121 1620000 8.12% 31 $ 18,207,019.192 15 PV = FV = Nper = 12377500 10311500 4 Using rate formula in excel Rate = -4.463% 19 PV = Rate Nper 13000 7.50% 6 Calculating the FV using excel FV = $ 20,062.920 Chapter 5 2 X PMT Nper Rate 3400 9 6% Calculating the present value using excel formula PV = Investment X is better at 6% rate $ 23,125.754 X PMT Nper Rate 3400 9 22% Calculating the present value using excel formula PV = Investment Y is better at 225 rate $ 5 Present value 12,873.369 years 24500 19700 136400 285650 6 8 15 20 10 Perpetuity = Rate = 30000 6% Present value = = Perpetuity / rate 500000 12 Stated rate Compunding 10% 17% 13% 9% 20 PV = APR = Nper Using excel formula to calculate monthly loan payment 4 12 365 2 73400 5.10% 60 PMT = $ Calculating the effective rate using excel formula Effective rate = 1,388.514 5.221% Chapter 6 3 Coupon rate Nper FV Rate Calculating the present value using excel formula PV = 7% 9 1000 8.40% $ 5 Nper FV PV Rate Calculating the coupon payments using PMT excel formula PMT = Rate = 7 Nper Coupon rate PV = FV = Calculating rate using Rate formula YTM = 913.980 12 1000 963 6.14% $ 56.95 5.695% 13 5.40% 940 1000 6.074% Interest rates Future value 9% 873 7% 3500 12% 326500 19% 213380 Y 5200 5 6% $ 21,904.292 Y 5200 5 22% $ 14,890.927 Interest rate Annuity 11% $ 5,791.226 7% $ 3,299.115 8% $ 15,935.550 6% $ 24,904.269 EAR 10.381% 18.389% 13.880% 9.202% Chapter 4 5 Present value years 195 2105 47800 38650 17.394 7.515 16.954 9.822 11 Fv = Nper Rate Calculating the PV using excel function PV = 1000000 80 7.25% $ 13 PV = FV = Nper = 150 1620000 119 Caclualting rate using RATE formula Rate = 8.12% Calculating the FV PV = Rate Nper = FV = 3,700.121 1620000 8.12% 31 $ 18,207,019.192 15 PV = FV = Nper = 12377500 10311500 4 Using rate formula in excel Rate = -4.463% 19 PV = Rate Nper 13000 7.50% 6 Calculating the FV using excel FV = $ 20,062.920 Chapter 5 2 X PMT Nper Rate 3400 9 6% Calculating the present value using excel formula PV = Investment X is better at 6% rate $ 23,125.754 X PMT Nper Rate 3400 9 22% Calculating the present value using excel formula PV = Investment Y is better at 225 rate $ 5 Present value 12,873.369 years 24500 19700 136400 285650 6 8 15 20 10 Perpetuity = Rate = 30000 6% Present value = = Perpetuity / rate 500000 12 Stated rate Compunding 10% 17% 13% 9% 20 PV = APR = Nper Using excel formula to calculate monthly loan payment 4 12 365 2 73400 5.10% 60 PMT = $ Calculating the effective rate using excel formula Effective rate = 1,388.514 5.221% Chapter 6 3 Coupon rate Nper FV Rate Calculating the present value using excel formula PV = 7% 9 1000 8.40% $ 5 Nper FV PV Rate Calculating the coupon payments using PMT excel formula PMT = Rate = 7 Nper Coupon rate PV = FV = Calculating rate using Rate formula YTM = 913.980 12 1000 963 6.14% $ 56.95 5.695% 13 5.40% 940 1000 6.074% Interest rates Future value 9% 873 7% 3500 12% 326500 19% 213380 Y 5200 5 6% $ 21,904.292 Y 5200 5 22% $ 14,890.927 Interest rate Annuity 11% $ 5,791.226 7% $ 3,299.115 8% $ 15,935.550 6% $ 24,904.269 EAR 10.381% 18.389% 13.880% 9.202%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started