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

Most languages are case sensitive so keywords can be

Most languages are case sensitive, so keywords can be written only one way, and the regular expressions describing their lexemes are very simple. However, some languages, like SQL, are case insensitive, so a keyword can ...

Beta ltd just paid a dividend of 040 and dividends are paid

Beta Ltd just paid a dividend of $0.40 and dividends are paid once a year. Dividends are expected to grow at 4% p.a. for each of the next five years and then to remain constant forever. Assume a required rate of return o ...

Ginger baker inc just paid an annual dividend of 3 a share

Ginger Baker, Inc. just paid an annual dividend of $3 a share and this dividend is expected to grow at a rate of 4% per year for the foreseeable future. If the discount rate for Ginger Baker is 9%, what is the current pr ...

1 describe how changes in level and trend can each be used

1. Describe how changes in level and trend can each be used to evaluate data in a single-subject design. 2. Describe the importance of the reversal phase in the ABAB design. 3. Describe the strengths and weaknesses of th ...

1 small savers can usually receive a higher interest rate

1. Small savers can usually receive a higher interest rate from money market mutual funds than from bank savings accounts. So, how are banks able to attract small savers? 2. Financial journalist David Wessel has describe ...

A scheme for the removal of h2s from a gas stream by

A scheme for the removal of H 2 S from a gas stream by scrubbing with water at 293 K and 1.013×10 5  Pa is being considered. The liquid will initially contain 3.7 mol % H 2 S. It is desired that the exiting gas stream co ...

The stock of bruin inc has an expected return of 22 percent

The stock of Bruin, Inc., has an expected return of 22 percent and a standard deviation of 35 percent. The stock of Wildcat Co. has an expected return of 14 percent and a standard deviation of 40 percent. The correlation ...

The shareholders of motive power corp need to elect four

The shareholders of Motive Power Corp. need to elect four new directors to the board. There are 14,900,000 shares of common stock outstanding, and the current share price is $11.10. If the company uses cumulative voting ...

1 in many industrialized countries the average inventory

1. In many industrialized countries, the average inventory turnover index is around 20 for dairy products and around five for household electrical appliances. Discuss these figures. 2. Consider a warehouse equipped with ...

How can a firm in need of short-term financing decide

How can a firm in need of short-term financing decide whether or not to take a cash discount offered by its supplier? How would this decision change in the event the firm has no alternative source of short-term financing ...

  • 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