Question

Loan 2 Beginning-of-month repayment 3 Interest Rate, i 4 Months, n 5 Amount of Loan 24 $1,500 Recreate the above in excel. Yo
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer: 77.95

Amount of loan = $ 1,500.

Monthly interest rate = 24.3 % / 12 = 2.025 % or 0.02025

n = 24

PVAD factor = [ { 1 - ( 1 / 1.02025 ) 24 } / 0.02025 ] * ( 1.02025) = 19.2424

Amount of monthly repayment = 1,500 / 19.2424 = 77.95

Add a comment
Know the answer?
Add Answer to:
Loan 2 Beginning-of-month repayment 3 Interest Rate, i 4 Months, n 5 Amount of Loan 24...
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
  • 4-103. You repay a student loan of $20,000 in equal monthly installments over 5 years at a nominal interest rate...

    4-103. You repay a student loan of $20,000 in equal monthly installments over 5 years at a nominal interest rate of 24%, compounded on a monthly basis. The interest rate remains constant over this entire period of time. What is the monthly repayment amount? (4.15)

  • solve question 1&2&3 please. as it is able, repay the loan plus accumulated interest at the...

    solve question 1&2&3 please. as it is able, repay the loan plus accumulated interest at the end of the quarter. 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. (Leave no cells blank-be certain to enter "0" wherever required. Do not round intermediate calculations. Omit the "S" sign in your response.) Schedule of Expected Cash Collections Cash sales Sales on account: May June July August Total cash collections 2. Prepare...

  • Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies....

    Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May $ 600,000 $900,000 420,000...

  • Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies....

    Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 540,000...

  • Problem 8-24 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies....

    Problem 8-24 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April $ 600,000 420,000 180,000 May...

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