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

1 what is validity2 distinguish between face validity

1. What is validity? 2. Distinguish between face validity, construct validity, and criterion-related validity. In general, which kind of validity is least important to researchers? 3. Can a measurement procedure be valid ...

1 an interest rate swap has two primary risks associated

1. An interest rate swap has two primary risks associated with it. Identify and explain each risk. 2. Define and explain a constant maturity swap. 3. Explain how an interest rate swap is a special case of a currency swap ...

1 explain how the publication financial analysis of the

1. Explain how the publication Financial Analysis of the Motor Carrier Industry could be used to determine the percentage of total revenue a firm has in relation to similar trucking firms. 2. Annual reports that insuranc ...

1 why is variance reduction important to logistical

1. Why is variance reduction important to logistical integration? Illustrate in terms of logistical operations. 2. What is the meaning of the phrase cradle-to-cradle logistics? Discuss the operational differences of orig ...

1 in what ways is the study of research methods valuable to

1. In what ways is the study of research methods valuable to students such as you? 2. Discuss the importance of systematic empiricism, public verification, and solvability to the scientific method. In what ways does pseu ...

You are the manager of a financially distressed corporation

You are the manager of a financially distressed corporation that has $5 million in loans, which come due in 30 days. Your firm has $4 million cash on hand. Suppose that a longtime supplier of materials to your firm is pl ...

Convert generic headings to talking headingsfrom a

Convert generic headings to talking headings. From a preliminary outline for a report, you have the following major and minor generic headings. Convert these to talking headings that you'll include in your final report. ...

In july 2010 congress was considering having the federal

In July 2010, Congress was considering having the federal government set up a "lending fund" for small banks. The U.S. Treasury would lend the funds to banks. The more of the funds the banks loaned to small businesses, t ...

1 how does lowest tco differ from lowest purchase price2

1. How does lowest TCO differ from lowest purchase price? 2. What is the underlying rationale that explains why firms should segment their purchase requirements? 3. Explain how constraints in manufacturing are interrelat ...

A car travels on a circular road with a radius r and

A car travels on a circular road with a radius R, and banking angle pheta. At what speed (vmax) does the car begin to skid if the static friction coefficient is us? Please show all work.

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen