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

1 visit the nvoad website and find out what organizations

1. Visit the NVOAD website, and find out what organizations are members of your state VOAD ( http://www.nvoad.org/membersdb.php?members state ). 2. Contact your state office of emergency management, and ask them if your ...

A nut having an effective length of 2 in and a 12-16 un

A nut having an effective length of 2 in. and a 1/2-16 UN thread is snug tightened and then turned 308. How much preload will that create in the bolt? Is that an acceptable preload? Describe the typical torque-turn tight ...

In july 2010 congress was considering having the federal

In July 2010, Congress was considering having the federal government set up a "lending fund" for small banks. The U.S. Treasury would lend the funds to banks. The more of the funds the banks loaned to small businesses, t ...

Make sense of data-as a marriage counselor you have

Make sense of data:- As a marriage counselor, you have gathered the following statistics: a. The average age at which women marry for the fi rst time has increased by 1.5 years in the last decade. b. The average age at w ...

What is an excess reserve and how is this different than

What is an excess reserve and how is this different than required reserves ? List at least four different types of insurance companies ? What is the difference between a mutual fund and a closed-end fund? If a mutual fun ...

1 why do researchers use factor analysis2 imagine that you

1. Why do researchers use factor analysis? 2. Imagine that you conducted a factor analysis on a set of variables that were uncorrelated with one another. How many factors would you expect to find? Why?

How does a conversion provision on a debt obligation

How does a conversion provision on a debt obligation provide an option to the investor? If the yield on a Treasury security is 3% and that of a similar-maturity municipal bond is 2.5%, what is the muni-Treasury yield rat ...

Using financial data from an appropriate source eg yahoo

Using financial data from an appropriate source (e.g. Yahoo Finance, Google Finance, annual reports, etc.), calculate the operating and cash conversion cycles for Darden Restaurants (ticker DRI). Explain what your answer ...

Smart analysts can massage the numbers in npv analysis to

Smart analysts can massage the numbers in NPV analysis to make any project's NPV look positive. It is better to use a simpler approach like payback or accounting rate of return that gives analysts fewer degrees of freedo ...

Future value kyle has 1000 in cash received for high school

Future Value. Kyle has $1,000 in cash received for high school graduation gifts from various relatives. He wants to invest it in a certificate of deposit (CD) so that he will have a down payment on a car when he graduate ...

  • 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