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 based on the following information construct a

1. Based on the following information, construct a traditional financial institution balance sheet AND a balance sheet including off-balance sheet items. Market value of assets = 200                                      ...

Sports corp has 115 million shares of common stock

Sports Corp has 11.5 million shares of common stock outstanding, 6.5 million shares of preferred stock outstanding, and 2.5 million bonds. If the common shares are selling for $26.5 per share, the preferred shares are se ...

Suppose you own an american call option on pfizer stock

Suppose you own an American call option on Pfizer stock. Pfizer stock has gone up in value considerably since you bought the option, so your investment has been profitable. There is still one month to go before the optio ...

In given problem what if mr nelligan was joined in the

In given Problem, what if Mr. Nelligan was joined in the foreclosure suit but forgot to attend the sale and bid? Does Mr. Nelligan have any other way of getting Ms. Rosen to pay? Problem:- Mort owns a property. Jessica R ...

Consider a projects incremental cash flows in order -700

Consider a project's incremental cash flows in order: -$700, $400, $300, $400. Assume a cost of capital of 7%. How does the NPV that you get by using Excel's NPV function all by itself compare to the correct NPV for this ...

Investigators studying the mass transfer from single

Investigators studying the mass transfer from single spheres recommended the generalized equation Sh = 2.0 + CRe m Sc 1/3 As discussed in section, the value of 2 can be derived theoretically by considering the molecular ...

1 contact your state national guard office find out what

1. Contact your state National Guard office. Find out what kinds of resources they can offer to assist local communities in the event of a disaster and what kind of training and exercises they conduct to prepare their me ...

Does a large bolt-to-joint stiffness ratio increase or

Does a large bolt-to-joint stiffness ratio increase or decrease the possibility of fatigue failure of the bolt and why? Name at least three bolt, thread, or bolt and thread configurations which can improve the fatigue re ...

Angelo purchased a 7 annual coupon bond one year ago for

Angelo purchased a 7% annual coupon bond one year ago for $987. At the time of purchase, the bond had six years to maturity. Over the past year inflation has been 3.2%. The market required return on this bond today is 8% ...

Consider the context-free grammara give a leftmost

Consider the context-free grammar: a) Give a leftmost derivation for the string. b) Give a rightmost derivation for the string. c) Give a parse tree for the string. ! d) Is the grammar ambiguous or unambiguous? Justify y ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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