I am having difficulty finding the correct formula for calculating the yield to maturity and internal rate of return. I am not a finance major and find this very difficult

Could you do problems 6-20 and 6-38 orn give a hint on how to complete?

(See attached file for full problem description)

Here are the cash flows for two mutually exclusive projects:

Project C0 C1 C2 C3
A ($20,000) $8,000 $8,000 $8,000
B ($20,000) 0 0 $25,000

a. At what interest rates would you prefer project A to B?

Growth Enterprises believes its latest project, which will cost $80,000 to install, will generate a perpetual
growing stream of cash flows. Cash flow at the end of this year will be $5,000 and cash flows in future
years are expected to grow indefinitely at an annual rate of 5 percent.

a. If the discount rate for this project is 10 percent, what is the project NPV?

6-20 NPV is the summation of discounted cash inflows and the initial investment. The formula to use for calculating NPV is use the NPV function to get the discounted sum of cash inflows and add the initial investment to get the NPV. Using this formula the NPV profile ...

Solution Summary

The solution explains how to calculate internal rate of return and yield to maturity

... the annual coupon payment, can be calculated by multiplying ...Calculating for IRR is a trial and error procedure ... calculation function in excel to calculate for us ...

Calculate the bond price and YTM in the given case. ... (A). If the yield to maturity on the bond is 10%, calculate the price of the bond ... (Compute IRR). ...

... Solutions to these problems depict the methodology to calculate the bond price, yield to maturity and ...YTM can be found by using IRR function in MS Excel ...

... 1115 1 70 2 70 3 1070 Coupon +Face Value Use IRR function to ... Solution describes the steps to calculate yield to maturity(YTM) and yield to call (YTC) for a ...

... Use IRR function in MS Excel to get YTM as under YTM=8.08%. ... Solution to second problem depicts the steps to calculate Yield to Maturity (YTM). ...

... Fixed Costs $40,000 Depreciation Expense $20,000 Tax Rate 40% Calculate the operating ... IRR=17+(1832/(790-1832)}20-17. ... nd of year 5 so no payback is calculated. ...

Calculating the current yield and yield to maturity. ... the cash flows attached with the bond and then calculate IRR. The IRR is the yield to maturity on the bond. ...

... 6 (1+IRR)7 + 2,000 = 0 (1+IRR)8 Calculating for IRR...IRR or IRR calculation function in excel to calculate for us ...IRR = 9.00% As the IRR is 9.00%, which is lower ...

... The solution explains how to calculate the WACC and use it to calculate the NPV ...YTM can be calculated using the RATE function We are given the following ...