Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use your parents, your relatives, or your own loan (either mortgage or auto loan) as an example to work out monthly payment schedules (For each

Use your parents, your relatives, or your own loan (either mortgage or auto loan) as an example to work out monthly payment schedules (For each month, list the total monthly payment, interest payment, and payment toward principal). List: 1. Total loan amount (If you want to protect privacy, you may multiply this number by 2, or 3, or 0.5) for first month and beginning balances for other months. 2. The starting month of the loan and number of years of amortization left. (monthly payment) 3. APR of the loan (normally the Rate quoted by the loan broker) 4. Monthly payment 5. Interest payment each month. 6. Payment toward principal. Check if the total interest payment last year (2016) you calculated is same as shown on form 1098 (Optional) . Put everything in Excel spreadsheet and use the spreadsheet formula. Please do not use any built-in formula from your broker or online mortgage resource if you are not able to fully explain the built-in formula.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Routledge International Handbook Of Financialization

Authors: Philip Mader, Daniel Mertens, Natascha Van Der Zwan

1st Edition

ISBN: 1138308218, 978-1138308213

More Books

Students also viewed these Finance questions

Question

Discuss the history of human resource management (HRM).

Answered: 1 week ago