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 oil and gas companies must disclose quantity estimates

1. Oil and gas companies must disclose quantity estimates for proved oil and gas reserves and the major factors causing changes in these resource estimates. Briefly indicate why this disclosure can be significant. 2. For ...

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, ...

Discussioncourse wrap-up please respond to the

Discussion "Course Wrap-Up" Please respond to the following: • Imagine you have completed your bachelor's degree at Strayer and you are searching for a job in finance, accounting or business. Using various employment web ...

Go to wwwbloombergcomnewseconomy and locate an article

Go to www.bloomberg.com/news/economy/ and locate an article related to a recent Federal Reserve action. Write a brief summary of the article, and explain what impact it is likely to have on the economy and you as an indi ...

Candy kane has taken out a 250000 mortgage at a quoted rate

Candy Kane has taken out a $250,000 mortgage at a quoted rate of 6.3% compoundedsemi-annually. If the mortgage requires monthly payments over a term of 20 years, with each payment made at the end of the period, what is t ...

1 what are the advantages and disadvantages of usinga

1. What are the advantages and disadvantages of using (a) figures, (b) tables, and (c) text to report the results of experiments in the research report? 2. Differentiate between random sampling and random assignment. Whi ...

An analyst predicted last year that the stock of logistics

An analyst predicted last year that the stock of Logistics, Inc., would offer a total return of at least 17% in the coming year. At the beginning of the year, the firm had a stock market value of $9 million. At the end o ...

Identify general-purpose statements and communication

Identify general-purpose statements and communication objectives for several situations. Read the following situations and write a general-purpose statement and a specific communication objective-the results you want-for ...

The mass m of drops formed by liquid discharging by gravity

The mass M of drops formed by liquid discharging by gravity from a vertical tube is a function of the tube diameter D, liquid density, surface tension, and the acceleration of gravity. Determine the independent dimension ...

A wetted-wall column as illustrated in figure 304 is used

A wetted-wall column, as illustrated in Figure 30.4, is used as a mass-transfer device for transferring ethyl acetate liquid to an air stream by a mass-transfer limited evaporation process. At the current conditions of o ...

  • 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