Question

# Bill has bought a new home in Canberra. He borrowed \$600000 at a rate calculated to...

Bill has bought a new home in Canberra. He borrowed \$600000 at a rate calculated to be 150 basis points over the Australian 10-year government bond yield for 2018.1 The loan is to be repaid in annual instalments over a thirty year period. The first instalment was due on 19 March 2020.

a. In your spreadsheet, in your first tab, draw up the loan repayment schedule for Bill. Calculate the annual loan repayment amount using Goal Seek.

#### Homework Answers

Answer #1

Australian 10-year government bond yield rate is not given so we assume rate is 3.25 %

So loan rate will be =3.25+1.50=4.75 ( 100 basis point = 1 percentage)

Using time value of time concepts we can find annual installment

Loan amount = Present value of all future installment

Loan amount = Installment amount × PVAF (4.75%,30 YEARS)

SO Installment amount = loan amount /PVAF (4.75% ,30 YEARS)

installment amount = 6,00,000/ 15.8204 (PVAF taken form annuity table)

= 37926 (round off)

Know the answer?
Your Answer:

#### Post as a guest

Your Name:

What's your source?

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Not the answer you're looking for?
Ask your own homework help question
ADVERTISEMENT
##### Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

ADVERTISEMENT
##### Active Questions
• The following command has been successfully executed: Create Sequence EmpSeq; The following block of PL/SQL code...
asked 12 minutes ago
• You own a mid-size company that designs 3-D imaging products. The government has requested you to...
asked 17 minutes ago
• J owns an 80% interest in the capital and profits of the JL partnership. On April...
asked 19 minutes ago
• For the population of infants subjected to fetal surgery for congenital anomalies, the distribution of gestational...
asked 28 minutes ago
• Bill needs to schedule a meeting for tomorrow afternoon, but he also has a tee time...
asked 35 minutes ago
• (a) True/False. A binary random variable is a categorical variable. Explain the answer thoroughly. (b) True/False....
asked 35 minutes ago
• Which of the following is TRUE about erythrocytes? Select one: a. Mature erythrocytes contain many ribosomes....
asked 54 minutes ago
• Muray Corp. is expected to pay the following dividends over the next 4 years: \$14, \$7,...
asked 1 hour ago
• After her yearly physical exam, a 45-year-old woman is told by her doctor that she has...
asked 1 hour ago
• A demand loan of ​\$8000.00 is repaid by payments of ​\$3500.00 after two ​years, \$3500.00 after...
asked 1 hour ago
• In May 2011, Mississippi River flooding hit Vicksburg, Mississippi, and the Optima Air Filter Company. Many...
asked 1 hour ago
• Choose the CORRECT statement about lymphatic fluid (lymph). Select one: a. Lymph is moved through lymphatic...
asked 1 hour ago