Reference no: EM132795840
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.
|
Briefly talk about the population that you intend to study
: Introduce your research question for the class project, and briefly talk about the population that you intend to study. Why did you choose to study this topic?
|
|
What is the total amount that will be paid during the loan
: What is the value of the payment that will occur in year 5? How much should the "ABC" Company pay to payoff the entire amount on July 1st, Year 8??
|
|
What will the monthly payment be on loan
: You have been offered a 30-year mortgage with a loan amount of $475,000. The rate will be 5.75%, with payment of 2 points at closing.
|
|
What has been the pattern of immigration
: What has been the pattern of immigration to the United States and how has this changed over time (perhaps because of changes in law, custom, attitudes, etc.)?
|
|
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 are the views of efficient markets
: What are the views of efficient markets, agency theory, and regulatory capture towards the behaviour of the parties involved in relation to financial reporting?
|
|
What is the forecasted amount of total cash collections
: Of these credit sales, 5% are collected during the month of sale, 25% in the following month, What is the forecasted amount of total cash collections in January
|
|
What is your own response to the findings
: What is your own response to these findings? Are these the types of interventions used at your fieldwork-or that you would consider using yourself?
|
|
What final payment will the bank require
: If the interest rate on the loan is 5%, what final payment will the bank require you to make so that it is indifferent to the two forms of payment?
|