Question

# If I borrow \$80,000 in loans for college and have to pay back the loan every...

If I borrow \$80,000 in loans for college and have to pay back the loan every month for 15 years after graduation. If the rate is 8%, what is the amount of my monthly loan payment?

Please explain to me how I would enter this information on Excel and how I can solve it. Thank you!

 Amount of monthly loan payment = Loan amount/Present value of annuity of 1 = \$       80,000 / 104.6381 = \$       764.54 Working: Present value of annuity of 1 = (1-(1+i)^-n)/i Where, = (1-(1+0.006667)^-180)/0.006667 i 8%/12 = 0.006667 = 104.6381 n 15*12 = 180

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Need Online Homework Help?

Most questions answered within 1 hours.

##### Active Questions
• A) What are the main differences between a) pre-transcriptional control, b) post-transcriptional control, and c) post-translational...
• The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to...
• Given the following information: Information Original Budget Actual Units produced 1,000 units 970 units Materials (kg)...
• A newly discovered toxin is known to impact female fertility. It acts to block hormones from...
• MobileCash Corporation operates a fleet of armoured cars that make scheduled pickups and deliveries for its...
• Managing Pension cost is a challenge for every Administration. If you are the Chief of NYC...