Reference no: EM132789482
1. An investor borrowed KShs. 4 Millions for investment purposes at an interest rate of 12%. The loan is to be repaid within a period of eight years.
Using the Excel Software:
i. Compute the annual loan repayment
ii. Prepare the loan repayment schedule showing clearly the interest and principal repayment each year.
2. Suppose the investor is valuing an investment which promises $ 4 000 at the end of every year for the next 5 years. If a bank pays an annual interest rate of 10% per annum on a 5- year deposit, compute the Net Present Value of the expected cashflows of this investment by summing the individual present values, using NPV and PV Excel's Functions.
3. As a finance manager, you are required to value a bond which pays annual coupon with the following terms: Term to Maturity 10years Maturity value $10,000 Discount rate (required yield) 6% Annual coupon payment 8%
Required:
i. Fair price and duration of the bond by summing the discounting cash flows Using Excel
ii. Using the Excel function DURATION given the settlement and maturity dates are 3rd December 2018 and 3rd December 2028 respectively
iii. Giving the reason, comment whether the bond is selling at a premium or loss.
|
Assess organization internal environment
: Assess the organization's internal environment. Perform competitor benchmarking.
|
|
What is the equity component of the original issuance
: The bonds would sell only at P4,600,000 without the conversion privilege. What is the equity component of the original issuance of the convertible bonds?
|
|
What amount of life insurance expense camay company should
: Camay Company purchased a P4,000,000 ordinary life, What amount of Life Insurance Expense Camay Company should report in its December 31, 20x9 profit or loss?
|
|
Create an exploratory perceptual map for the product
: Looking back at the health care organization you identified in the first assignment, choose a specific product offered by that organization.
|
|
Compute the annual loan repayment
: 1. An investor borrowed KShs. 4 Millions for investment purposes at an interest rate of 12%. The loan is to be repaid within a period of eight years.
|
|
What amount of share premium should be recorded as result
: When the bonds were originally issued, the equity component was recorded at P1,500,000. What amount of share premium should be recorded as result of conversion?
|
|
What is hypopituitarism and how is it managed
: What is hypopituitarism and how is it managed? Compare and contrast the pathophysiology of Syndrome of Inappropriate Antidiuretic Hormone (SIADH) and Diabetes.
|
|
What is the present value of the cost of the machine
: The scrap value of the loom is 7,000 lira. The capital cost of the company is 20%. What is the present value of the cost of this machine to the company?
|
|
Discuss the overall purpose people have for investing
: 1. Discuss the overall purpose people have for investing. Define investment.
|