Create a complete amortization schedule for the car

Assignment Help Accounting Basics
Reference no: EM131015613

The scenario is designed to help you determine and evaluate the payment amount of a car loan and a mortgage, based on the assumption that your household income is $36,000 per year or $3,000 per month. Based on your income, you may spend 28% of your monthly income on housing, and 10% on a car loan. You are to put a 3% down payment on the house and a 10% down payment on the car.

Required:

Using Microsoft Excel, address the following issues:

1. What is the maximum car payment and mortgage payment you can afford with the following conditions: your monthly household income, 10% for the car payment, and 28% for the mortgage payments?

2. Assume a 10% down payment on the car and a 3% down payment on the house. Also, assume that you can get financing for the car at 7% for 60 months, and the house can be financed at 5% for 30 years. How much could you spend on the car and the house? You must submit your calculations in a Microsoft Excel document showing how answers were reached.

3. Create a complete amortization schedule for the car, using the information in questions 1 and 2.

4. Discuss the distributions of principal, interest and the balance over the life of the loan.

Reference no: EM131015613

Questions Cloud

Prepare a schedule of debt reduction : Prepare all the necessary journal entries on the books of Crocker Corp. for the years 2014, 2015, and 2016.
Which of the following is not a renewable resource : Which of the following is not a renewable resource?Select one:a. the sun beating down on a rain foresb. plants, such as bamboo and rice, growing in moist environmentsc. oil reserves, buried deep below the surface of the groundd. water flowing through..
Which nutrient enters an ecosystem : Which nutrient enters an ecosystem from a geologic rather than atmospheric reservoir? Select one:a. carbonb. phosphorusc. nitrogend. oxygen
Which of the biomes below could be described : Which of the biomes below could be described as one with cold winters and mostly coniferous trees receiving low amounts of rain each year?
Create a complete amortization schedule for the car : Create a complete amortization schedule for the car, using the information in questions 1 and 2.
How is the value of it assessed in your organization : What is the level of IT-business integration for your organization? How is the value of IT assessed in your organization? How might your organization improve IT strategic alignment with business
Calculate the amount of the revised annual payment : A man has a 30-year loan with level end of year payments. The principal repaid in year 5 is 159.68 and in year 10 is 213.73. What is the payment - What was the nominal interest rate convertible quarterly for the last 2 years?
Comparing walmart and amazon business models : Analyze the case study comparing Walmart and Amazon's business models and business strategies
What is the value of the inductance l : The figure shows voltage and current graphs for an inductor. What is the emf frequency f? What is the value of the inductance L?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Purchases made on sonic sales company

Purchases made on Sonic Sales Company credit cards submit payments

  The bakery produces tea cakes it uses a process costing

the bakery produces tea cakes. it uses a process costing system. in march its beginning inventory was 450 units which

  Determine whether each of the ollowing independent

1. determine whether each of the ollowing independent statements best applies to a defined contribution plan dcp a

  Several of the judges point out what is significantly miss

Several of the judges point out what is significantly missing from the way Esanda pleaded its case. It is these missing elements which, the judges are saying, point to the lack of a duty of care owed by the auditors to Esanda. What are these missing ..

  Assignment on public university analysis

Select a public university system and review the financial statements and audit report for the system. Write a three to four (3-4) page paper in which you:

  Question regarding the appollo corporation

Appollo Corporation reported the following accounts and balances in its financial statements.

  Preferred stockholders entitled

What dividends are the preferred stockholders entitled to receive in the current year before any distribution is made to common stockholders?

  Multiple choice questions

Accounting basics Multiple choice questions.  Make your selection by recording the letter in the answer box provided.

  During the year equipment was sold for rp1200000000 cash

sams structures desires to buy a new crane and accessories to help move and install modular buildings. the machine

  Company has a joint process which produces three products

company has a joint process which produces three products called a b and c. each product may be sold at split-off or

  In october overhead was underapplied by 1360 the company

kuvomi corporation worked on four jobs during october job f346 job f347 job f348 and job f349. at the end of october

  Calistoga produce estimates bad debt expense at 020 of

calistoga produce estimates bad debt expense at 0.20 of credit sales. the company reported accounts receivable and

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