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 describe and illustrate an integrated service provider

1. Describe and illustrate an integrated service provider. How does the concept of integrated service provider differ from traditional service providers, such as forhire transportation and warehousing? 2. Compare and con ...

1 what are the main reasons that corporations may choose to

1. What are the main reasons that corporations may choose to own real estate? 2. Why is the value of corporate real estate often considered "hidden" from shareholders? 3. Why is the cost of financing with a sale-leasebac ...

Each of the following studies examines the relationship

Each of the following studies examines the relationship between the quality of breakfast and academic performance for third-grade children. Identify which is correlational, which is experimental, and which is nonexperime ...

The following appeared in an article in the wall street

The following appeared in an article in the Wall Street Journal: Credit Suisse Group equity-derivatives strategist Sveinn Palsson suggests a "strangle" in the company's options. The strategy involves selling a call and a ...

1 discuss the rationale and risks associated with using a

1. Discuss the rationale and risks associated with using a common forecast to drive the firms planning/coordination flow. 2. Discuss the role of the CRM system in enhancing the firms competitiveness. 3. Discuss how advan ...

1 design an observational study of your own including the

1. Design an observational study of your own, including the creation of a set of behavioral categories that would be used to code for one or more variables of interest to you. Indicate the decisions that you have made re ...

1a how does a company become exposed to interest rate riskb

1.(a) How does a company become exposed to interest rate risk? (b) How does a bank become exposed to interest rate risk? 2 .How might a company attempt to reduce interest rate risk? 3. How might a bank attempt to reduce ...

1 when and why would nonprobability sampling methods be

1. When and why would nonprobability sampling methods be used? 2. Under what conditions is sampling bias likely to occur, what are its effects on generalization, and how can it be avoided? 3. Indicate the similarities an ...

A building owner is evaluating the following four

A building owner is evaluating the following four alternatives for leasing space in an office building for the next five years. Write a two-three page paper and prepare an Excel spreadsheet evaluating each of the four di ...

1 as chief financial officer you sell newly issued bonds on

1. As chief financial officer you sell newly issued bonds on behalf of your firm. Your firm is: a. borrowing indirectly. b. borrowing directly. c. lending directly. d. lending indirectly. 2. In which of the following ins ...

  • 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