Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 functionsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started