Question

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.

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)

home healthcare has just borrowed $2,000,000 on a five-year,
annual payment term loan at a 15 percent rate. the first payment is
due one year from now. construct the amortization schedule for this
loan
please explain using PMT in excel format. I need to input this
into excel

Today is October 1, 2XX1. Justine has just bought a home in
beautiful Rockford, IL. The selling price of home was $310,000.
Justine made a down payment of 20% and borrowed the balance. She
was able to negotiate a 2-year ARM with an initial teaser rate of
2.00% and subsequent annual rates equal to the current 90-day
T-Bill rate on the loan’s anniversary date (October 1) plus 1.10%.
The loan is for 30 years with annual and lifetime caps of...

Assume that you have found a home for sale and have agreed to a
purchase price of $254800$254800.
Down Payment: Assume that you are going to make a
10%10% down payment on the house. Determine the amount of your down
payment and the balance to finance.
Down Payment=$Down Payment=$
Loan Amount=$Loan Amount=$
Monthly Payment: Calculate the monthly payment for
a 30 year loan (rounding to the nearest cent, so rounding to two
decimal places). For the 30 year loan use...

Total utility can be objectively measured in numbers that
indicate usefulness or benefit to the consumer.
____ 2. Consumers should purchase quantities of a good to the
point where MU > P.
____ 3. Voluntary exchange requires that there must be mutual
gain.
____ 4. Points along a budget line represent the maximum
combinations of two commodities that a consumer can afford.
____ 5. The budget line represents a consumer's preferences
for a commodity.
____ 6. A change in consumer...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 12 minutes ago

asked 17 minutes ago

asked 19 minutes ago

asked 28 minutes ago

asked 35 minutes ago

asked 35 minutes ago

asked 54 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago