Create an amortization schedule

Assignment Help Finance Basics
Reference no: EM13298166

The case is designed to determine and evaluate the payment amount of a car loan and a mortgage, based on your income. If you prefer, you may assume that your household income is $48,000 per year or $4,000 per month. Based on your income, you may spend 28 percent of your monthly income on housing and 10 percent on a car loan. You are to put a 3 percent down payment on the house and a 10 percent down payment on the car. These will make the loan to value of your loans to less than one: 97 percent on the house and 90 percent on the car.

1. Determine the car payment and mortgage payment with the following conditions: your monthly household income, 10 percent for the car payment, and 28 percent for the mortgage payment. Also, assume a 10 percent down payment on the car and a 3 percent down payment on the house.

2. Create an amortization schedule, and graph the components over time: interest, principal, and balance.

3. Discuss the distributions of principal, interest and the balance over the life of the loan. You must submit your backup in Excel or other supporting documentation showing how answers were reached.

 

Reference no: EM13298166

Questions Cloud

What was the actual (ex post) real return : What was the actual (ex post) real return?
Transaction in which either all of the database actions : A transaction in which either all of the database actions occur or none of them do is called:
What is effective in changing physician behavior : For what reason did managed care originally emerge in the early 1900s? What did the HMO Act of 1973 do? What are the rules for patients in closed-access HMOs? What is the principle role of the member services department? What is effective in changing..
Hre a high skilled worker : What is the probability that the employer will hire a high skilled worker?
Create an amortization schedule : Discuss the distributions of principal, interest and the balance over the life of the loan. You must submit your backup in Excel or other supporting documentation showing how answers were reached.
Buyer value number of buyers : Participating in the market for a product are 12 consumers, each of whom will buy at most one unit of the good, and 11 suppliers, each of whom will sell at most one unit of the good. The distribution of buyer values is as follows:
What is the annual reporting period for this company : At year end employees earned wages of $7,000 which will be paid on the next payroll date, January 6 2012.
What amount must be invested today at an interest rate : What amount must be invested today at an interest rate of 4½%, compounded monthly, if you want to purchase a $450,000 machine 4 years in the future?
What is the new market value of the company : Again Inc is proposing a rights offering . Presently , there are 450,000 shares outstanding at $90 each. There will be 80,000 new shares offered at $84 each.

Reviews

Write a Review

Finance Basics Questions & Answers

  Estimate of the maximum share price for the purchase

After examining your analysis, the CFO of Happy Times is uncomfortable using the perpetual growth rate in cash flows. Instead, she feels that the terminal value should be estimated using the EV / EBITDA multiple. The appropriate EV / EBITDA multip..

  How much could the machine be sold for today

A financial analyst calculate that the after-tax salvage value for amachine was $10,200. The current book value of the asset is $12,000 and the firm's rate is 30%. How much could the machine be sold for today?

  Computation of ytm and analysis of bond returns

Computation of YTM and analysis of bond returns and Explain why your bond is trading at a premium or discount based on current market conditions

  Time value of money techniques

Based solely on time value of money techniques (rationale), do you think it is logical for people to over pay their taxes during the year and get a refund?

  Why would bofa issue all those warrants

Why would BofA issue all those warrants? Remember, think like an analyst- Warren Buffet invested in BofA last year and as part of the deal

  Which one of following increase that stocks rate of return

World United stock currently plots on the security market line and has a beta of 1.04. Which one of the following will increase that stocks rate of return without affecting the risk level of the stock, all else constant?

  Should the old stemer be replace

To support the greater sales, the new machine would require that inventories increase by $2,900, but accounts payable would simultaneously increase by $700. parker marginal federal-plus-state tax rate is 40%, and its WACC is 14%. Should it replace..

  What are apples business models

Apple has been successful in expanding its product and service portfolio from computers to MP3 players to mobile phones. What are Apples's business models? Describe the core competencies that have allowed Apple to make the moves from Mac to iP..

  What is your estimate of carpetto cost of common equity

Assuming you have equal confidence in the inputs used for the three approaches, what is your estimate of Carpetto's cost of common equity? Round your answer to two decimal places.

  What was the stock return for the missing year

If the average return of the stock over this period was 10 percent, what was the stock's return for the missing year? What is the standard deviation of the stock's return?

  Compute operating and financial leverage

Illinois Tool Company's  fixed operating costs are $1,260,000 and its variable cost ratio is 0.70. The company has $3,000,000 in bonds outstanding at an interest rate of 8 percent.

  What is the most important segment of a cash flow statement

What is the most important segment of a cash flow statement? Why? Can the cash flow statement be manipulated? If so, how? If not, why not? Are most investors sophisticated enough to interpret a cash flow statement? Should they be?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd