If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end of year 3. The required payment for the project will increase by 4% every year. With this in mind, the investors will deposit an investment amount to a bank account with an interest rate of 7% per year. The deposits will occur at the end of year 1, year 2, and year 3, respectively. Information about this project is shown in the figure below: 390 000.00 4.00 7.00 3 1 Required payment present value) 2 Rate of increase per year if payment is not paid of * Account interest rate per year 4 Year of pay off 5 6 7 Required payment 3 years later (using FV function B Required deposit at end of each year (using PMT function) 9 Depesit at end Year el year 1 Accumulated account balance at end of year 12 13 15 Round your answers to two (2) decimal points. Calculate the project payment amount if it will only be paid three years later and the required deposit at the end of each year if investors were to settle this payment at the end of year 3. State the Excel formula for Cell B7 and Cell B8. Write down the Excel formulas for Cells B13:C15. Suppose the investors now decided to increase the yearly deposit by a growth rate g of 3% . Calculate the growth-adjusted rate and express it in percentage. If the value of the growth rate (3%) is stated in Cell B5, state the Excel formula to calculate the annuity payment at the end of Year 1 (i.e,C(1 + g)) (15 marks) A $1,000 zero-coupon bond makes payment of the face value at maturity. How would you value the price of a zero-coupon bond and decide if you should buy the zero-coupon bond? Is the bond selling at premium, at discount or at par? (3 marks) (b) Question 1 If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end of year 3. The required payment for the project will increase by 4% every year. With this in mind, the investors will deposit an investment amount to a bank account with an interest rate of 7% per year. The deposits will occur at the end of year 1, year 2, and year 3, respectively. Information about this project is shown in the figure below: 1 Required payment (present value) 2 Rate of increase per year if payment is not paid off 3 Account interest rate per year 4 Year of pay off $90,000.00 40 7.00 7 Required payment 3 years later (using FV function) Required deposit at end of each year (using PMT function) 10 Deposit at end Accumulated account Year of year balance at end of year 12 13 15 Round your answers to two (2) decimal points. Calculate the project payment amount if it will only be paid three years later and the required deposit at the end of each year if investors were to settle this payment at the end of year 3. State the Excel formula for Cell B7 and Cell B8. Write down the Excel formulas for Cells B13:C15. Suppose the investors now decided to increase the yearly deposit by a growth rate g of 3%: Calculate the growth-adjusted rate and express it in percentage. If the value of the growth rate (3%) is stated in Cell B5, state the Excel formula to calculate the annuity payment at the end of Year 1 (i.e.. C(1 +g)). (15 marks) A S1,000 zero-coupon bond makes payment of the face value at maturity. How would you value the price of a zero-coupon bond and decide if you should buy the zero-coupon bond? Is the bond selling at premium, at discount or at par? (3 marks) (b) If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end of year 3. The required payment for the project will increase by 4% every year. With this in mind, the investors will deposit an investment amount to a bank account with an interest rate of 7% per year. The deposits will occur at the end of year 1, year 2, and year 3, respectively. Information about this project is shown in the figure below: 390 000.00 4.00 7.00 3 1 Required payment present value) 2 Rate of increase per year if payment is not paid of * Account interest rate per year 4 Year of pay off 5 6 7 Required payment 3 years later (using FV function B Required deposit at end of each year (using PMT function) 9 Depesit at end Year el year 1 Accumulated account balance at end of year 12 13 15 Round your answers to two (2) decimal points. Calculate the project payment amount if it will only be paid three years later and the required deposit at the end of each year if investors were to settle this payment at the end of year 3. State the Excel formula for Cell B7 and Cell B8. Write down the Excel formulas for Cells B13:C15. Suppose the investors now decided to increase the yearly deposit by a growth rate g of 3% . Calculate the growth-adjusted rate and express it in percentage. If the value of the growth rate (3%) is stated in Cell B5, state the Excel formula to calculate the annuity payment at the end of Year 1 (i.e,C(1 + g)) (15 marks) A $1,000 zero-coupon bond makes payment of the face value at maturity. How would you value the price of a zero-coupon bond and decide if you should buy the zero-coupon bond? Is the bond selling at premium, at discount or at par? (3 marks) (b) Question 1 If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end of year 3. The required payment for the project will increase by 4% every year. With this in mind, the investors will deposit an investment amount to a bank account with an interest rate of 7% per year. The deposits will occur at the end of year 1, year 2, and year 3, respectively. Information about this project is shown in the figure below: 1 Required payment (present value) 2 Rate of increase per year if payment is not paid off 3 Account interest rate per year 4 Year of pay off $90,000.00 40 7.00 7 Required payment 3 years later (using FV function) Required deposit at end of each year (using PMT function) 10 Deposit at end Accumulated account Year of year balance at end of year 12 13 15 Round your answers to two (2) decimal points. Calculate the project payment amount if it will only be paid three years later and the required deposit at the end of each year if investors were to settle this payment at the end of year 3. State the Excel formula for Cell B7 and Cell B8. Write down the Excel formulas for Cells B13:C15. Suppose the investors now decided to increase the yearly deposit by a growth rate g of 3%: Calculate the growth-adjusted rate and express it in percentage. If the value of the growth rate (3%) is stated in Cell B5, state the Excel formula to calculate the annuity payment at the end of Year 1 (i.e.. C(1 +g)). (15 marks) A S1,000 zero-coupon bond makes payment of the face value at maturity. How would you value the price of a zero-coupon bond and decide if you should buy the zero-coupon bond? Is the bond selling at premium, at discount or at par? (3 marks) (b)