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

Finance1on a typical day park place clinic writes 1000 in

Finance 1. On a typical day, Park Place Clinic writes $1,000 in checks. It generally takes four days for those checks to clear. Each day the clinic typically receives $1,000 in checks that take three days to clear. What ...

Ai enterprises is a computer corporation and its present

AI Enterprises is a computer corporation and its present sources of funds are $20,000,000 in equity capital and $8,000,000 in preferred stock. The company wants to fund some of its future projects (estimated cost: $12,00 ...

Explain the difference between a forward contract and an

Explain the difference between a forward contract and an option? What factors distinguish a forward contract from a futures contract? What do forward and futures contracts have in common? What advantages does each have o ...

Maxines pumps or mp sells bilge pumps for 355 each each

Maxine's Pumps or MP sells bilge pumps for $355 each. Each pump costss $255 to produce, and MP's fixed operating costs equal $700,000. What is MP's operating income (NOI) when 10,000 pumps are sold?

The following excerpts are taken from dividend policy

The following excerpts are taken from "Dividend Policy Determinants: An Investigation of the Influences of Stakeholder Theory" by Mark E. Holder, Frederick W. Langrehr, and J. Lawrence Hexter, published in the Autumn 199 ...

An all-equity firm has 100000 shares outstanding worth 10

An all-equity firm has 100,000 shares outstanding worth $10 each. The firm is considering a project that requires an investment of $400,000 and has an NPV of $50,000. The company is also considering financing this projec ...

1 what is a capitalization rate what are the different ways

1. What is a capitalization rate? What are the different ways of arriving at this rate for an appraisal? 2. If investors buy properties based on expected future benefits, what is the rationale for appraising a property b ...

1 how do reward systems serve as barriers to enterprise

1. How do reward systems serve as barriers to enterprise integration? 2. In your words, describe and illustrate the great divide. Do you believe the great divide phenomenon is as widely experienced as the text indicates? ...

1 by how much will the clamping force on the joint be

1 .By how much will the clamping force on the joint be reduced? Sketch the new joint diagram, assuming maximum initial preload ? Compute the estimated maximum bolt tension and minimum clamping force under the 3,000 lbs e ...

1 why consider agency and corporate bonds over treasuries2

1. Why consider agency and corporate bonds over Treasuries? 2. What are the major reasons why investors should consider buying convertible bonds? 3. What are the risks of zero-coupon securities?

  • 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