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 discuss how any company can become an mnc what are some

1. Discuss how any company can become an MNC. What are some of the options available to companies that allow them to use international markets and locations competitively? 2. Discuss some reasons why reductions in world ...

Before entering graduate school a student estimated the

Before entering graduate school, a student estimated the value of earning an MBA at $300,000. Based on that analysis, the student decided to go back to school. After completing the fi rst year, the student ran the NPV ca ...

On august 20 a stock index futures which expires on

On August 20 a stock index futures, which expires on September 20, was priced at 429.70. The index was at 428.51. The dividend yield was 2.7 percent. Discuss the concept of the implied repo rate on an index arbitrage tra ...

Figure 942 is one depth-first presentation of the ow graph

Figure 9.42 is one depth-first presentation of the ow graph of Fig. 9.38. How many other depth-first presentations of this ow graph are there? Remember, order of children matters in distinguishing depth-first presentatio ...

Go to wwwfdicgovconsumersconsumerinformationfdiciornhtml

Go to www.fdic.gov/consumers/consumer/information/fdiciorn.html and answer the following questions: a. List at least three types of bank accounts that are insured by the FDIC. Are money market deposit accounts insured an ...

1 which of the gaps in figure do you think represents the

1. Which of the gaps in Figure do you think represents the major problem for most firms? How can a company attempt to eliminate the knowledge gap? The communications gap? 2. Compare and contrast the customer service, cus ...

1 why might a borrower be willing to pay a higher price for

1. Why might a borrower be willing to pay a higher price for a home with an assumable loan? 2. What is a buy down loan? What parties are usually involved in this kind of loan? 3. Why might a wraparound lender provide a w ...

You have an absolutely brilliant child who is six years old

You have an absolutely brilliant child who is six years old and will be attending a private college in twelve years. You know that in twelve years a four-year college will cost at least $70,000 per year (total $280,000), ...

A company has 1 00000 to invest in new rampd projects the

A company has $1, 00,000 to invest in new R&D projects. The company wants to determine what set of projects should be selected.   The following table summarizes the initial cost and revenue potential for each of the proj ...

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 ...

  • 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