Question: pls give explanations, thanks! Complete each task by inserting the appropriate function, referencing the appropriate cells in the task data, in the specified cells. Task
pls give explanations, thanks!
Complete each task by inserting the appropriate function, referencing the appropriate cells in the task data, in the specified cells. Task 1 Data Task 2 Data Loan Amount Interest Rate" Number of Payments $175,000.00 4.25% 360 Monthly Payment Interest Rate Number of Payments $1,200.00 4.25% 360 Monthly Payment Loan Amount Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. + Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Task 3 and 4 Data Task 5 Data Loan Amount Monthly Payment Number of Payments 212,000.00 $950.00 360 Monthly Savings Amount Interest Rate* Number of Months $75.00 2.75% 36 Nominal Interest Rate Effective Interest Rate Future Account Balance *Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Remember to multiply the nominal interest rate by 12 (to calculate the annual interest rate) Task 6-8 Data 15 Year Mortgage 30 Year Mortgage Loan Amount Interest Rate Number of Payments 310,000.00 4.50% 180 $310,000.00 4.50% 360 Monthly Payment Total Payments (PMT * # of PMTs) $0.00 $0.00 Difference between 30-year and 15-year payback (the 30 year amount the 15 year amount) Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your functions
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
