Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

Please show work in Excel along with a detailed written explanation of your findings typed in word format.

Mini-Project 1: Mortgage Loan Analysis: Mr. Johnson plans to buy a new house at Sugar Land in June 2010. The sale price of the house is $580,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo Bank with a 30-year, 5.25% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from July 2010 for a total of 30 years.

(1) find out the required monthly payment for Mr. Johnson.
(2) Construct 2010~2011 amortization table (18 months) for Mr. Johnson.

(1) Mr. Johnson should prepare his 2010 tax filings in early 2011. Please compute the total mortgage interest payments which he can use for his 2010 tax deductions.

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M928304

Have any Question? 


Related Questions in Basic Finance

Abc corporation just paid a dividend of 150 a share the

ABC Corporation just paid a dividend of $1.50 a share. The dividend is expected to grow at 10% a year for the next 2 years, and the 5% per year thereafter. The required return to invest in ABC stock is 10.50%. What shoul ...

How do options on futures differ from options on the asset

How do options on futures differ from options on the asset underlying the futures? The open interest in a futures contract changes from day to day. Suppose that investors holding long positions are divided into two group ...

Find data to decide whether to open a store-you have been

Find data to decide whether to open a store:- You have been asked to determine the feasibility of opening a frozen yogurt store in Greenville, North Carolina. Answer the following questions, using the latest figures avai ...

A project has initial outlay of 2791 it has a single payoff

A project has initial outlay of $2791. It has a single payoff at the end of year 4 of $8578. what is the profitability index (PI) of the project, if the company's cost of capital is 6.06 percent.

How would a relatively high home inflation rate affect the

How would a relatively high home inflation rate affect the home country's current account, all other thing being equal? How would you expect a weakening home currency to affect the home country's current account, all oth ...

An investor has 60000 to invest in a 280000 property he can

An investor has $60,000 to invest in a $280,000 property. He can obtain either a $220,000 loan at 9.5 percent for 20 years or a $180,000 loan at 9 percent for 20 years and a second mortgage for $40,000 at 13 percent for ...

1 discuss the differences between the following types of

1. Discuss the differences between the following types of mergers: a. Horizontal mergers b. Vertical mergers c. Conglomerate mergers 2. What are some of the reasons why firms merge with other firms? 3. What methods do fi ...

In a talk at the white house in december 2009 president

In a talk at the White House in December 2009, President Barack Obama argued: "Ultimately in this country we rise and fall together: banks and small businesses, consumers and large corporations." Why in this statement, d ...

Gun manufacturer bloodbath amp beyond currently has a cash

Gun manufacturer Bloodbath & Beyond currently has a cash balance of $750,000. It projects that cash outflows of $390,000 a month. The company pays a fee of $500 every time it sells securities through its broker and the a ...

1 how can an investor increase the amounts that they save2

1. How can an investor increase the amounts that they save? 2. How can investors benefit from the compounding of interest (time value of money)? 3. Match the objectives to the different types of investment groups (money ...

  • 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