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

For each of the following studies consider whether or not

For each of the following studies, consider whether or not you think the research is ethical, how the research may have violated principles of ethical behavior, and what, if any, alternative research methods for testing ...

Flip a set of ten coins one hundred times and record the

Flip a set of ten coins one hundred times, and record the number of heads and tails each time. Construct a frequency distribution of the observed data. Check whether the observed frequency distribution appears to match t ...

1 deriving from the conclusion of proposition i what is the

1. Deriving from the conclusion of Proposition I, what is the crux of M&M Proposition II? What is the natural relationship between the required returns on debt and on equity that results from Proposition II? 2. In what w ...

Discussion 1 170 wordsidentify a futures commodity exchange

Discussion 1: (170 words) Identify a futures commodity, exchange, stock, or interest rate. Use the internet to find a short history of the performance of this futures contract. Then research the possible reasons for this ...

Interpret the following statements about value at risk so

Interpret the following statements about Value at Risk so that they would be easily understood by a nontechnical corporate executive: a. VAR of $1.5 million, one week, probability = 0.01. b. VAR of $3.75 million, one yea ...

1 how are the results of factorial experimental designs

1. How are the results of factorial experimental designs reported in the research report? 2. What is the purpose of means comparisons, and what different types of means comparisons are there? What do they tell the resear ...

1 which of the gaps in figure 3- 1 do you think represents

1. Which of the gaps in Figure 3- 1 do you think represents the major problem for most firms? How can a company attempt to eliminate the knowledge gap? The communications gap? 2. Compare and contrast the customer service ...

The following excerpt is taken from a publication of the

The following excerpt is taken from a publication of the American Institute of Certified Public Accountants (we won't give the title since it is the answer to one of the questions): Great strides have been made by the FA ...

Imagine that the us congress decides to completely overhaul

Imagine that the U.S. Congress decides to completely overhaul the current federal income tax system because of its tremendous complexity and is considering using national retail sales taxes replace income taxes. Compare ...

Required for each of the following numbered items you are

Required For each of the following numbered items, you are to select the lettered item(s) that indicate(s) its effect(s) on the corporation's statements. If more than one effect is applicable to a particular item, be sur ...

  • 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