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 factors must one consider when deciding on the

1 .What factors must one consider when deciding on the appropriate underlying asset for a hedge? 2. For each of the following hedge termination dates, identify the appropriate contract expiration. Assume the available ex ...

Cost of debt the zephyr corporation is contemplating a new

(Cost of debt) The Zephyr Corporation is contemplating a new investment to be financed 33 percent from debt. The firm could sell new $1,000 par value bonds at a net price of $930. The coupon interest rate is 14 percent, ...

Formulate a polling station location problem taking into

Formulate a polling station location problem, taking into account the following binding constraints: (a) the number of polling stations is fixed for each municipality and calculated according to the number of resident vo ...

Suppose you think msft stock is going to appreciate

Suppose you think MSFT stock is going to appreciate substantially in the next yr. The stock's current price is $100and call options expiring in 1 yr has an exercise price of $100 and is selling for $5. With $1,000 to inv ...

According to an article in the wall street journal in late

According to an article in the Wall Street Journal, in late 2009, "Between Dec. 9 and 11, some big European and U.S. banks made bearish calls on the euro by buying one-year euro ‘puts.'" a. What is a "bearish call"? b. W ...

The performance of a journal bearing around a rotating

The performance of a journal bearing around a rotating shaft is a function of the following variables: Q, the rate of flow lubricating oil to the bearing in volume per unit time; D, the bearing diameter; N, the shaft spe ...

1 suppose that in the lasim problem the transport cost

1. Suppose that in the Lasim problem, the transport cost between the production site and the warehouse is not negligible. In this case, the inventory replenishment of product A-124 has a transport cost of € 25. Determine ...

We have seen that federal reserve chairman ben bernanke has

We have seen that Federal Reserve Chairman Ben Bernanke has argued that low interest rates in the United States during the mid-2000s were due to a global savings glut rather than to Federal Reserve policy. In an intervie ...

What is meant by the term prevailing torque what do we

What is meant by the term prevailing torque? What do we mean by the terms initial preload and residual preload? Why do they differ? What limits the usefulness of the so-called, long-form torque-preload equation? Explain ...

Cost estimation and budgetingan important aspect of cost

Cost Estimation and Budgeting An important aspect of cost budgeting is personnel. A current professional issue in the engineering field is companies using contract engineers like employees but refusing to actually make t ...

  • 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