Question
The right answer is F but I don’t know how to do it
u Mr. and Mrs. LN. Debt took out a 10-year, SI 55,000 loan at a rate of 36 % per year, comp ounded monthly They decided to pay the balance on the loan after paying 5 years worth of payments. The payoff amount for the loan is closest to .. a) $70,554.26 b) $70,406.11 c)$93,657.35 d) S61,342.65 e) $84,334.58 ) $84,445.74 g) $84,753.18 h) $70,665.42 i) $70,758.90 j) $91,834.32 k) $57,841.0 I) $57,459.88 m) $102,322.50 n) $101, 994.36 o) $77,500 P) S55,800 q) $5,580
0 0
Add a comment Improve this question Transcribed image text
Answer #1

the principal amount of loan is $155,000 and we shall pay an equal monthly installment for 10 years to repay the loan.

so, as per original terms, we are required to pay $1540.00 as calculated in the image.

now we shall calculate the future value of $155,000 at 60th month when the loan is to be repaid. (FV1)

we shall also calculate the future value of 60 installments of $1,540.00 paid at 60th month when the loan is to be repaid. (FV2)

now that both the figures are at 60th month, we shall deduct the FV2 from FV1 to know the principal loan remaining and that shall be the payoff amount.

formula view -

C15 X fFV(C4,C6,-C8, C2,0) principal amount annual rate of interest monthly rate of interest number of years number of months present value annuity factor (0.30%, 120 periods) equated annual installment- 2 155000 0.036 4 C3/12 6 7 -C5*12 -Q124 C2/C7 FV1 FV2 Payoff amount -FV(C4,C6,0,C2,0) -FV(C4,C6,C8,0,0) -C10-C11 10 12 13 14 15 16 17 18 19 20 21 alternatively, they can be calculated by a single formula too as shown below - Payoff amount -FV(C4,C6,-C8,C2,0) hence, the correct answer is f) $84,445.74

Add a comment
Know the answer?
Add Answer to:
The right answer is F but I don’t know how to do it u Mr. and...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The right answer is B I don’t know what I’m doing wrong insert R510D USB Use...

    The right answer is B I don’t know what I’m doing wrong insert R510D USB Use the following information to answer questions 4.5 and 6. MARR-20% Initial Cost Benefits O&M Costs Alternative #1 $270,000 S100,000 in year I; $125,000 in year 2 remainingyearsincrease by 10%morethanthe previousyear S20,000 in year increasing by $1,000 per year Salvage $55,000 Life (in years) The Net Present Worth of Alternative #1, over the given lifespan. is closest to a) $332,673 b)S171963 c) $163,320 d) $219,958...

  • Can’t use excel the correct answer is H, but I don’t know how the professor got...

    Can’t use excel the correct answer is H, but I don’t know how the professor got it 11. Mrs. where they enthusi fund interest rate o Daisy Flowers and her husband, Bud, have a daughter named Rose. They live in the town of Petal, MS y own their own florist shop, "Flowers by Flowers", or as the locals call it, Flowers. They are gardening asts and desire to beautify their hometown. Fortunately, the couple is able to donate $2 Million...

  • how do i plug in 29,991.12xPV0.6667%,5 in my financial calculator BA II Plus Mr. Bond agrees...

    how do i plug in 29,991.12xPV0.6667%,5 in my financial calculator BA II Plus Mr. Bond agrees to repay a loan by paying $600 at the end of EACH month for 5 years. The first payment is due at the end of the 6th month from today and the last payment will be at the end of five and a half years (66 months). If the interest rate is 8% compounded monthly, find the amount of the loan today. Choose the...

  • the answer is from the solution is -386 but i dont know how to get to...

    the answer is from the solution is -386 but i dont know how to get to that number. Can you help me? account ta for last year are pres presenter A) 25,000 B) 30,000. c) 55,000 Amount 250 A country's international transactions accounts data for la Transaction 1.000 Exports of goods and services 1,400 Import of goods and services 250 Investment income payments made to foreigners 340 Investment income received from foreigners 150 Net change in assets owned abroad 490...

  • please answer the question1-5. Case Study in Accounting: LIGHTS, CAMERA, ACTION! Andrew Son is a Grade...

    please answer the question1-5. Case Study in Accounting: LIGHTS, CAMERA, ACTION! Andrew Son is a Grade 11 high school student in Richmond Hill, Ontario. He enjoys school and does very well in most of his classes, especially accounting. He likes accounting so much that he plans to become a Chartered Professional Accountant when he finishes university. Andrew started his first part-time job last summer as an usher at the local movie theatre, the Yorkland Theatre The Yorkland Theatre is a...

  • 76. Consider the following letter and answer Shady's question. To my friendly student tax preparer: Hello,...

    76. Consider the following letter and answer Shady's question. To my friendly student tax preparer: Hello, my name is Shady Slim. I understand you are going to help me figure out my gross income for the year whatever that means. It's been a busy year and I'm a busy man, so let me give you the lowdown on my life and you can do your thing. I was unemployed at the beginning of the year and got $2,000 in unemployment...

  • Only need the ledger done! Have everything else completed, just confused how to do the ledger...

    Only need the ledger done! Have everything else completed, just confused how to do the ledger INSTRUCTIONS AND TRANSACTIONS FOR THE CHAPTER 3 "BIG" PROJECT WORTH 100 POINTS NOTE: YOU MUST USE THE PROJECT WORKPAPERS (EXCEL FILE) PROVIDED IN D2L CONTENT / CHAPTER 3 FOLDER. NO OTHER FILES WILL BE ACCEPTED. On January 1, 2019, Bruce Wayne created a new Crime Watch agency called Batman's Watchdog Service. The following transactions occurred during the company's first month of operations: Jan 1...

  • Case Study in Accounting: LIGHTS, CAMERA, ACTION! Andrew Son is a Grade 11 high school student...

    Case Study in Accounting: LIGHTS, CAMERA, ACTION! Andrew Son is a Grade 11 high school student in Richmond Hill, Ontario. He enjoys school and does very well in most of his classes, especially accounting. He likes accounting so much that he plans to become a Chartered Professional Accountant when he finishes university. Andrew started his first part-time job last summer as an usher at the local movie theatre, the Yorkland Theatre The Yorkland Theatre is a small theatre owned by...

  • Case Study in Accounting: LIGHTS, CAMERA, ACTION! Andrew Son is a Grade 11 high school student...

    Case Study in Accounting: LIGHTS, CAMERA, ACTION! Andrew Son is a Grade 11 high school student in Richmond Hill, Ontario. He enjoys school and does very well in most of his classes, especially accounting. He likes accounting so much that he plans to become a Chartered Professional Accountant when he finishes university. Andrew started his first part-time job last summer as an usher at the local movie theatre, the Yorkland Theatre The Yorkland Theatre is a small theatre owned by...

  • please answer all in full 1. On your 1st birthday, you received a $10 savings account...

    please answer all in full 1. On your 1st birthday, you received a $10 savings account earning 6% annually. How much will you have in the account on your 30th birthday if you don't withdraw any money before then? 2. Your partner just promised to you that he/she will give you a graduation gift by paying half of of a new car when you receive an MBA degree in 2 years. Suppose that you also have $9,000 to invest today...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT