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

  Determine annual worth of the most profitable course

Both alternatives have a useful life of 20 years and no market value at that time. The MARR is 20 % per year. Determine the annual worth (AW) of the most profitable course of action. (Enter your answer as a number without the dollar sign.)

  How much should the firm be willing to pay

If average daily remittances are $2 million, and "extended disbursement float" adds 2 days to the disbursement schedule, how much should the firm be willing to pay for a cash management system if the firm earns 11% on excess funds.

  What is progressive cost of equity and corporate cost

The CFO estimates that the present value of any future financial distress costs is $8 million, and that the probability of distress increases with the amount of debt in the following steps.

  Calculation of financial leverage and operating

Calculation of financial leverage, operating and combined leverage and the firm's direct labor costs increase as a result of a new labor contract

  What is the market price

Wine and Roses, Inc. offers a 7% coupon bond with semiannual payments and a yield to maturity of 7.73%. The bonds mature in 9 years. What is the market price of a $1,000 face value bond?

  Generic benchmarking worksheet

This Generic Benchmarking Worksheet includes 2 examples of each major section of the assignment:

  What is the present value of the second option

You can have $8,500 per month for the next three years, or you can have $7,200 per month for the next three years, along with a $38,500 signing bonus today. Assume the interest rate is 8 percent compounded monthly.

  Explain what is the net present value of this project

What is the net present value of this project if the relevant discount rate is 14 percent and the tax rate is 35 percent? Round your answer to the nearest dollar.

  What is the breakeven volume

A: Breakeven problem: What is the breakeven volume when the fixed costs are $60,000.

  What was the net loss in dollars

In dollars, sales were $698,266. What was the net loss in dollars? (Do not include the dollar sign ($). Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places (e.g., 32.16).)

  Caluing business opportunities

Suppose that the role of finance section at Strident Marks. The finance section has a couple of new hires, and the CFO has asked that you spend a short amount of time with them,

  Explain decision on selecting a machine

Explain Decision on selecting a machine and compute the equivalent annual cost for both machines

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