FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am trying to use the PMT formula on excel to create an amortization for 15 and 30 years respectively. the loan 220,000. interest rate

I am trying to use the PMT formula on excel to create an amortization for 15 and 30 years respectively. the loan 220,000. interest rate 15 years 3.125 and 20years 3.625.' every time I am using the excel the data is not accurate . Please show me how to use PMT for amortization

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

Handbook Of Key Global Financial Markets Institutions And Infrastructure

Handbook Of Key Global Financial Markets Institutions And Infrastructure

Authors: Gerard Caprio

1st Edition

0123978734, 9780123978738

More Books

Students also viewed these Finance questions

Question

★★★★★
Based on a Pitney Bowes survey, when 1009 consumers were asked if they are comfortable with drones delivering their purchases, 42% said yes. Consider the probability that among 30 different consumers...

Answered: 1 week ago

Question

★★★★★
4. Muscle spindles provide information about muscle stretch. Gamma motor neurons help the muscle spindle match the length of the muscle, providing continuous feedback. (LO3)

Answered: 1 week ago

Question

★★★★★
Garden Grove Corporation made a sale to a foreign customer on September 15, Year 1, for 100,000 foreign currency units (FCU). Payment was received on October 15, Year 1. The following exchange rates...

Answered: 1 week ago

Question

★★★★★
I am trying to use the PMT formula on excel to create an amortization for 15 and 30 years respectively. the loan 220,000. interest rate 15 years 3.125 and 20years 3.625.' every time I am using the...

Answered: 1 week ago

Question

★★★★★
One of the products that the sporting - goods retail chain, Sports World, sells is parachutes. In the first quarter of 2 0 2 4 , Sports World sold 6 5 0 parachutes. Budgeted sales for the remainder...

Answered: 1 week ago

Question

★★★★★
Next Generation Ltd Trial balance on 31 December 2019 Debit Credit Share capital 570,000 Property, plant, and equipment 2,100,000 Bank 195,000 Revenue 480,000 Rental income 35,000 Cost of sales...

Answered: 1 week ago

Question

★★★★★
Perform the following steps with pen and paper - you should not write code for these steps: Write down your PI (personal identifier). Your PI will be different from your OUCU, but like your OUCU it...

Answered: 1 week ago

Question

★★★★★
What are the three private IP ranges? What are some scenarios where private IP addresses can be used? Briefly compare and contrast Static NAT, Dynamic NAT, and PAT. Using the drawing, how would you...

Answered: 1 week ago

Question

★★★★★
You decide that you need to change the ways you interact with the sales staff. Which of the following actions would best remodel your behavior based on the persuasion principle of being what the...

Answered: 1 week ago

Question

★★★★★
Using FNMA's website takes patience and practice, which is why we asked you to poke around and familiarize yourself with its search functions. We want to hear your opinion. Please answer the...

Answered: 1 week ago

Question

★★★★★
6. Describe how communication can reinforce cultural beliefs and behavior.

Answered: 1 week ago

Question

★★★★★
7. The celebration of Buddhas birthday is not held on Christmas, but instead on: a. Fourth of July b. July 14 c. Asian Lunar New Years Day d. Hanamatsuri

Answered: 1 week ago

Question

★★★★★
10. Describe the relationship between communication and power.

Answered: 1 week ago

Previous Question Next Question