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

Use the normal distribution of fish lengths for which the

Use the normal distribution of fish lengths for which the mean is 11 inches and the standard deviation is 4 inches. Assume the variable x is normally distributed. A. What % of the fish are longer then 12 inches B. If 400 ...

1 explain the risk premium on a bond2 explain what is meant

1. Explain the risk premium on a bond. 2. Explain what is meant by the risk-return trade-off. 3. Explain how the yield curve can assist bond investors.

A newly issued 10 year bond is valued at par on june 1 2017

A newly issued 10 year bond is valued at par on June 1, 2017. The bond has an annual coupon of 8.0 percent. On June 1 2020, the bond has a yield to maturity of 7.1 percent. The first coupon is invested at 8.0 percent and ...

1 what kinds of things do volunteer organizations provide

1. What kinds of things do volunteer organizations provide for victims in the aftermath of a disaster? 2. What is the Incident Command System, and why was it originally developed? 3. What are the five major management sy ...

1 what is a currency swap2 what is a credit swap in what

1. What is a currency swap? 2. What is a credit swap? In what ways is it different from an interest-rate swap? 3. What is a credit default swap? What difficulties did credit default swaps cause during the financial crisi ...

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

For each of the following six scenarios say whether the

For each of the following six scenarios, say whether the value of the dollar will appreciate, depreciate, or remain the same relative to the Japanese yen. Explain each answer. Assume that exchange rates are freely floati ...

1 what are some important lease provisions which investors

1. What are some important lease provisions which investors should be aware of when analyzing the financial statements of REITs? 2. List and characterize equity REITs based on their property types.

Assignment budget planning and controlbefore approaching

Assignment: Budget Planning and Control Before approaching this assignment, be sure that you have watched the following video. • Budgetary Planning featuring Babycakes *FULL VIDEO*. (2016). YouTube. Babycakes, a specialt ...

In april 2010 christina romer who was then serving as chair

In April 2010, Christina Romer, who was then serving as chair of the President's Council of Economic Advisers, argued: "The overwhelming weight of the evidence is that the current very high-and very disturbing-levels of ...

  • 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