DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Bill would like to borrow $50, 000 and pay it off in 10 years. What components will he need to identify for a loan amortization schedule created on an Excel worksheet?
|
|
beginning and ending loan balance
|
|
|
year, rate, monthly interest
|
|
|
beginning and ending loan balance and the amount of payment that applies to the principal and interest per year
|
|
|
interest paid at the beginning and end of the year
|
Explanation:
Detailed explanation-1: -Starting in month one, take the total amount of the loan and multiply it by the interest rate on the loan. Then for a loan with monthly repayments, divide the result by 12 to get your monthly interest. Subtract the interest from the total monthly payment, and the remaining amount is what goes toward principal.
Detailed explanation-2: -A loan amortization schedule is a table that shows each periodic loan payment that is owed, typically monthly, for level-payment loans. The schedule breaks down how much of each payment is designated for the interest versus the principal.
There is 1 question to complete.