Question: Please solve in excel You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a

Please solve in excel

You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a balance owed of $200,000. The bank will loan the remaining balance at 3.91% APR. You will make annual payments with a 30 -year payment schedule. What is the annual annuity payment under this schedule? A. $18,100.23 B. $11,009.49 C. $6,666.67 D. $11,439.96

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

please explain the work You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a balance owed of $200,000. The bank will loan the remaining balance at...

You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a balance owed of $200,000. The bank will loan the remaining balance at 3.91% APR. You will...

please help with all parts of questions 1-8 from creating the balance sheet and income statement... to calculating the ratios, interpreting those ratios , and whether or not she can achieve her...

Hello, Please help in creating a balance sheet ( question 1) and a cash flow (question 2). This is for a couple and the purpose is for financial planning and budgeting. The information, their...

Hello, I have the following questions below. Question 1 is to produce a personal balance sheet for financial planning purposes. Question 2 is to create a cash flow for the same purpose. The...

Please solve using excel sheet cell formulas. Thank you. Input the number of items purchased in cell F13 by referencing the appropriate cell in the model inputs. Input the total price of items...

Please help! I am supposed to use the January 1st , 2019 asset and liability information, in order to develop a balance sheet. (Assuming no unpaid bills). Assets on a balance sheet should be listed...

(46 Marks) On 31 January 2017 Janine Youngman, 56 years old, resigned as an employee of Sport-Gear Limited. She had been employed as a buyer for the companys teenage range of goods since 2010. Upon...

Ontario Fun Space (OFS) is a privately owned entertainment complex consisting of a theme park, concert venue, and marina in Lions Head, Ontario. OFS was founded in 1988 by a group of 10 local...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

In an ideal Otto cycle, air is compressed from 1.20 kg/m3 and 2.2 to 0.26 L, and the net work output of the cycle is 440 kJ/kg. The mean effective pressure (MEP) for this cycle is (a) 612 kPa (b) 599...

A galvanometer has a rectangular coil of side 10 by 30 mm pivoted about the center of the shorter side. It is mounted in radial magnetic field so that a constant magnetic field of 0.4 Wb/m2 always...

12. What are closing entries, and why are they necessary?

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...