Reference no: EM132613719
Instruction: For the following questions, with the help of the formulas learnt in topic 1 and 2, you are to use excel and calculate:
1. You plan to borrow $15,000 for a 10-year term, at 15% simple interest per annum. Calculate the interest charges for each of the years and the accumulated amount at the end of each year in excel using tables.
2. You plan to borrow $15,000 for a 10-year term, at 15% compound interest per annum. Calculate the interest charges for each of the years and the accumulated amount at the end of each year in excel using tables
3. An investor deposits $20,000 into a savings account for 2 years that earns 4% annual interest, compounded monthly. Calculate the interest charges for each of the period and the accumulated amount at the end of each period in excel using tables.
4. Find the future value of an annuity, that pays $25,000 at the end of each year for 11 years at 9%, using excel.
5. Calculate the present value of an annuity, that pays $5,000 per year for 8 years at 5 percent assuming that the first payment is made after 2 years, using excel.
Provide a full Microsoft excel for the question and also provide a full working for each question in word document
|
What is the bond straight-debt value
: Neuman Corporation Convertible Bonds, Refer to the data for the Neuman Corporation's convertible bonds. What is the bond's straight-debt value?
|
|
Theory and concepts learned in corporate finance
: Explain how commerce students may benefit from the theory and concepts learned in Corporate Finance?
|
|
Find how much in dividends if any will pay
: Target capital structure of 30% debt and 70% equity. If the company follows the residual dividend policy, how much in dividends, if any, will it pay?
|
|
Discuss similarities and differences in the several groups
: How would you incorporate the key factors into your plan for working with clients from these groups and What are the key factors that need to be addressed
|
|
Calculate the interest charges for the years
: You plan to borrow $15,000 for a 10-year term, at 15% simple interest per annum. Calculate the interest charges
|
|
Emerging trend for businesses in today environment
: Corporate social responsibility is an emerging trend for businesses in today's environment.
|
|
What is the npv if nww refunds the bonds today
: What is the NPV if NWW refunds its bonds today? Five years ago, NorthWest Water (NWW) issued $50,000,000 face value of 30-year
|
|
Weighted average cost of capital-rodriguez corporation
: Rodriguez Corporation is constructing is cost of capital schedule. The target capital structure is based on the market values of the company
|
|
Define tests to determine nutritional status of your patient
: Patient malnutrition is a very real and serious matter; it can lead to a worsening of the patient's condition, a longer hospital stay, or even be as serious.
|