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

Complete the given assignment-two population meansa tomato

Complete the given assignment:- Two Population Means A tomato farmer with a very large farm of approximately 2200 acres had heard about a new type of rather expensive fertilizer which would supposedly significantly incre ...

Read one practical article of how psychology affects paying

Read one practical article of how psychology affects paying credit card debt. You can easily retrieve possible articles by doing an online search using the terms "psychology" and "credit card debt." Summarize the main po ...

1 identity theft what constitutes identity theft2 identity

1. Identity Theft. What constitutes identity theft? 2. Identity Theft. Is identity theft only perpetrated to acquire money, goods, or services? 3. Impact of Identity Theft. Aside from the financial losses, what other neg ...

Options can protect a firm against the downside risk of a

Options can protect a firm against the downside risk of a business transaction while preserving the upside potential from the transaction. In contrast, forward and futures contracts normally protect against the downside ...

1 compare the assessment of face content and construct

1. Compare the assessment of face, content, and construct validity. Which of the three approaches is most objective, and why? Is it possible to have a measure that is construct valid but not face valid? 2. What is the im ...

Assignmentanswer questions-what are the two principal ways

Assignment Answer questions: -What are the two principal ways in which Congress and state legislatures exercise oversight of administrative agencies? -In what ways does the budgeting process lend itself to political cont ...

Directions update the data with your recommendations for

Directions: Update the data with your recommendations for the blue cells, then use Solver to determine the minimum variance portfolio Choose the index for each asset class, type the name below and paste in the relevant r ...

1 how do the industrial patterns observed for dividend

1. How do the industrial patterns observed for dividend payouts compare with the patterns observed for capital structures? For example, are industries characterized by high dividend payouts also characterized by high lev ...

1 why do researchers use inferential statistics2

1. Why do researchers use inferential statistics? 2. Distinguish between the null hypothesis and the experimental hypothesis. 3. When analyzing data, why do researchers test the null hypothesis rather than the experiment ...

1 how would stephanies banking service decisions be

1. How would Stephanie's banking service decisions be different if she were a single mother of two children? 2. How would Stephanie's banking service decisions be affected if she were 35 years old? If she were 50 years o ...

  • 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