Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please, help me with the excel assignment and show the instruction on how to type them on excel. Instruction: Calculate Loan Payment using PMT Function.

Please, help me with the excel assignment and show the instruction on how to type them on excel. image text in transcribed

Instruction: Calculate Loan Payment using PMT Function. All cells must contain formulas (i.e., typing the number directly into the cells will be graded as incorrect answers). 1.1 Susan purchases a Mazda 6 for $22,000. To pay for the car, she will make monthly payments over 4 years, annual interest rate = 5.25%. What are the monthly payments? Put the formula for the claculation in the cell A6. 1.2 What is the total amount (interest and principal) that Susan will have to pay for the car? 1.3 How much interest will Susan pay? 2.1 Ryan purchases a house for $120,000 to be paid for over 30 years at an interest rate of 6.25% per year. What are the monthly payments? 2.2 What is the total amount (interest and principal) that Ryan pay for the house? 2.3 How much interest does Ryan pay? Future Value Instruction: Calculate the amount of money using FV Function. All cells must contain formulas (i.e., typing the number directly into the cells will be graded as incorrect answe 1.1 If John deposits $200 in the bank each month for 5 years where the annual interest rate is 7.5%, how much does he have in the bank at the end of the five years? 1.2 How much interest does John earn during the five years? 13.1 Pochol donorite $100 por month for Fusare into on account that nous 60 annual How much is in Dorhol's account at

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_2

Step: 3

blur-text-image_3

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

Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz

5th edition

134128524, 978-0134128528

More Books

Students also viewed these Accounting questions