How much is the monthly repayment

Assignment Help Corporate Finance
Reference no: EM13821783

General Information:

a) You must have the correct answer and a correct explanation plus working to gain the marks allocated to each part. Include cash flow maps or tables wherever possible. Avoid rounding error. Providing a formula and the answer is not enough. Some questions have more than one part, where this is the case you must get all parts correct to gain your one mark.

b) Format: Calculation and brief working or short answer with explanation as well as the calculation solved in an Excel spread sheet. For each calculation you must provide a manual solution and a solution using excel. If you have two files you should embed your excel file into your word document and submit only one file. Typing straight into excel without doing the calculations in excel does not qualify as using excel.

c) Word Limit: 300 words as a very rough guide; mostly calculations.

d) It must be done in excel. You can type your explanations in Word if you wish but with an embedded excel file or done all in excel.

e) Make sure to highlight or underline your final answer.

f) Try to be as accurate as possible. Cross-check your answers using excel. Unless otherwise told you should use the following approach:

a. PV and FV accurate to the nearest dollar
b. Prices accurate to two decimal places
c. Rates accurate to one basis point

Outline

You should solve the following ten questions showing your full workings and explanations in brief form. Each question is worth one mark. You must have the correct answer and show your working and correct explanation to get one mark (very brief or one to two line of answers are not acceptable). As well as solving the problems manually using the appropriate formulas you must also solve the problems using Excel functions/calculations. An incorrect answer or an answer without the working will be given zero. Normally no part marks are awarded. For questions where two or more answers are requested you must get all parts correct to guarantee the one mark. Include cash flow maps or tables wherever possible. Avoid rounding error.

Read the questions carefully

Question 1:

Now that they have accumulated a deposit of 65,000 Jack and his partner Jill wish to take out a housing loan to purchase a home. The house costs $555,000. The loan is to be repaid in equal monthly instalments over a term of 25 years. The interest rate quoted by the bank is an effective annual rate of 6.42%pa. Jack has misplaced the paperwork showing the annual nominal rate (j12) with monthly compounding.

i. How much is the monthly repayment?
ii. How much interest will be paid in the second year?
iii. How much do Jack and Jill owe the bank immediately before making the 180th repayment?
iv. Produce a repayment schedule in Excel for the loan. Use it to confirm the answers in parts i to iii.

Question 2:

Today is Peter's 54th birthday. He plans to retire on his 65th birthday. He wants to put aside the same sum of money every birthday (starting today) up to and including his 65th. He then wants to be able to withdraw $29000 every birthday (starting with his 65th) up to and including his 85th birthday. He believes that an interest rate of 6.5% pa is a reasonable estimate of the opportunity cost of funds. How much does he need to put away each birthday?

Question 3:

Peter has received a bequest of a lump sum of 110,000 from his Aunt's will, but it is not due to be available for him for seventeen years (t = 17). Peter wants to receive the cash earlier than this. He is investigating a deferred annuity with the first annual cash flow of the annuity is to be paid at the beginning of year 3 (fifteen cash flows). Assume that the annuity and the lump sum are of equivalent risk and that j12 = 7.20% pa is the appropriate interest rate (opportunity cost of funds for Peter).

How much is the annual cash flow associated with the annuity?

Question 4:

In exchange for a lump sum payment now, DABsuper offers an annual pension over twenty five years beginning with a payment of $55,000 at the end of the first year. There are twenty five payments in total and the payments will increase at an annual rate of 3%pa. The appropriate opportunity cost of funds is j2 = 8%pa what is the amount of the lump sum needed today to purchase the pension?

Question 5:

a) A ninety day bank bill with 90 days to maturity has a price of $98078. What is the effective annual yield implied by this price and maturity? Be careful I am not asking for the annual nominal yield, which by convention is normally quoted in financial markets. Face value is $100,000.

b) What would be the price of this bank bill if you decide to sell it with 70 days left to maturity and the appropriate interest rate is 7.22%pa effective?

c) Calculate the geometric average rate of return over four years given the following annual rates, year 1 = 5.24%, year 2 = 6.79%, year 3 = 8.57%, year 4 = 9.23%. (geometric nor arithmetic)

Reference no: EM13821783

Questions Cloud

Role of microsystem in shaping childrens effortful control : role of the microsystem in shaping children's effortful control
Analyze three of the punishments that corporations undergo : Analyze three of the punishments that corporations undergo when they have acted unethically (i.e., name them, define them, explain what they are). In addition, explain three threats to running an ethical corporation.
Who should do the prioritization of the project risks : As the work of your risk management team (from the first discussion question) continues, the discussion of your team's risk management plan outline moves on and considers the following questions: Who should do the prioritization of the project risks?..
Evaluate the administration of this event : Evaluate the administration of this event... Was it well planned and managed throughout? Are some steps in the planning process missing based on your Reading and your Event Planning Guide? If so what are they and why should they be included
How much is the monthly repayment : How much is the monthly repayment - How much interest will be paid in the second year and how much do Jack and Jill owe the bank immediately before making the 180th repayment?
Determines a leaders effectiveness : Describe what effective leadership means to you. Who determines a leaders’ effectiveness? Provide details and examples to support your thoughts
What is federalism : What Is Federalism
Discuss three changes you would make to the supreme court : Discuss three changes you would make to the Supreme Court to make it better in your opinion and why you would make those changes
Essay on the influence of entrepreneurship in health care : Write a 1,050-word essay on the influence of entrepreneurship in health care. Include the following in your essay:

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Computation of return on stock using capm approach

Computation of return on stock using CAPM approach - Other things held constant, if the expected inflation rate decreases and investors also become more risk averse, the Security Market Line would shift

  Compute accounts receivable and inventory turnover ratio

Compute the accounts receivable and inventory turnover ratios for 19X5. Alaska rounds all calculations to two decimal places.

  Financial accounting is fairly heavily regulated in

financial accounting is fairly heavily regulated in australia. there are numerous corporations act requirements and

  Cost of preferred equity taylor systems has just issued

cost of preferred equity taylor systems has just issued preferred shares. the shares have a 12 percent annual dividend

  The cost of capital1 why is the firms weighted average

the cost of capital1. why is the firms weighted average cost of capital wacc considered a hurdle rate?2. explain the

  What are some internal control procedures over cash

Internal controls help ensure the safeguarding of the company's assets. One of the major areas that need to be safeguarded is cash. What are some internal control procedures over cash?

  Determine the expected cash flow from operations

Montejo Corporation expects sales to be $12m, operating expenses other than depreciation are expected to be 75% of sales, & depreciation to be $1.5m during the next year.

  Article review financial statements financial planning and

article review financial statements financial planning and growth time value of moneydiscounted cash flow valuation

  Calculate free cash flow using ebit

Calculate cash flow provided by operating activities, calculate free cash flow using CFO and calculate free cash flow using EBIT

  A typical answer should have about 500 words but it is the

a typical answer should have about 500 words but it is the quality of the answer that matters not the number of words.

  1 a 1000 par value bond was issued 25 years ago at a 12

1 a 1000 par value bond was issued 25 years ago at a 12 coupon rate. it currently has 10 years to maturity. interest is

  How much additional spendable income will each investor have

How much additional spendable income will each investor have if the business is organized as a partnership rather than as a corporation?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd