Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

You can purchase a new building within the city limits for $525,000.
The city will offer a special incentive reducing the price by $25,000.
The city will finance the building over a period of 20 years at a 5.25% APR
Should you pay the loan off 5 years early the city will rebate you an additional 10% of the purchase price

I have figured out what to do, however, I am having a hard time putting this into an Excel Spreadsheet. Please review this method and place the following into a spreadsheet.

Involves borrowing $500,000 ($525,000 minus the 25K incentive) for 15 years at an annual interest rate of 5.25%

PMT formula would look something like this:

=INT/12,TERM*12-Amt Borrowed

You're dividing the Annual Interest Rate by 12 to determine the actual interest that you pay on each payment.

You're multiplying the Term by 12 to determine the Total Number of Payments made

The Amt Borrowed should have a minus sign in front of it in your Function

Once you've find outd your Monthly PMT just multiply it by the Total Number of PMTs made

=TERM*12*PMT to determine the Total Cost of the house

DO NOT forget to subtract $50,000 from it because you paid off the loan in 15 years.
answer should be $673,XXX..94

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M927071

Have any Question? 


Related Questions in Basic Finance

The past five monthly returns for pgampe are -355 percent

The past five monthly returns for PG&E are -3.55 percent, 4.83 percent, 4.15 percent, 7.04 percent, and 3.96 percent. Compute the standard deviation of PG&E's monthly returns. (Do not round intermediate calculations and ...

Assignment-investmentsa general bond and investor

Assignment- INVESTMENTS A. GENERAL BOND AND INVESTOR INFORMATION 1. Briefly discuss the general characteristics of the bond touching on: a. A brief description of the company that issued the bond. b. A brief description ...

In excercises 17-36 assume that a randomly selected subject

In excercises 17-36, assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph and find th ...

Do you think the new dialysis center will be able to

Do you think the new Dialysis Center will be able to attract more patients? What impact would additional volume have on the facilities allocation decision?

Commercial paper who issues commercial paperwhat types of

Commercial Paper : Who issues commercial paper? What types of financial institutions issue commercial paper? Why do some firms create a department that can directly place commercial paper? What criteria affect the decisi ...

Finance assignmentpart 1problem 1find the following values

Finance Assignment Part 1 PROBLEM 1 Find the following values for a lump sum: - The future value of $500 invested at 8 percent for one year - The future value of $500 invested at 8 percent for five years - The present va ...

Comment on the european central banks ecb activities in the

Comment on the European Central Banks (ECB) activities in the debt markets under the expanded asset purchase programme. Are they active in securitisation markets?

Questionhypothesis testing scenariocaptionnbspas you

Question: Hypothesis Testing Scenario Caption:  As you prepared your memo about the new "Tire Kit" line, you discovered that the sample size that you were provided was insufficiently small. Using a larger sample of 200 c ...

You are looking to buy a car you can afford 430 in monthly

You are looking to buy a car. You can afford $430 in monthly payments for four years. In addition to the loan, you can make a $1,200 down payment. If interest rates are 7.50 percent APR, what price of car can you afford? ...

Monetary policy during the credit crisisduring the credit

Monetary Policy during the Credit Crisis : During the credit crisis, the Fed used a stimulative monetary policy. Why do you think the total amount of loans to households and businesses did not increase as much as the Fed ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate