User Account

All Pages

What is the amount of money that you will need to borrow

Assignment Help Accounting Basics
Reference no: EM131561528

Auto Loan - USE FORMULAS WHEREEVER POSSIBLE!

You have decided to buy a 2007 FORD MUSTANG. The total cost with tax, title, license and optional equipment is $28,900. You will make a down payment equal to 20% of the total cost of the car. The remaining amount will be financed.

You have two financing options.  You need to represent BOTH in your spreadsheet.

Option 1 - Get $3,000 cash back. This amount will reduce the amount you need to finance. You will be able to get a 5 year car loan on the remaining amount with a 5.70% interest rate from your bank.

Option 2 - Get no cash back and finance the entire amount. The loan will be for 3 years with a 0.0% interest rate from Ford Co. financing.

Answer the following in your own words in your spreadsheet:

a. What is the amount of money that you will need to borrow under Option 1?

b. What is your monthly payment for Option 1?

c. What is the total amount paid over the term on the loan for Option 1 (i.e. total cost)?

d. How much will you need to borrow if you choose option 2?

e. What is your monthly payment?  

f. What is the total amount paid over the term on the loan for Option 2 (i.e. total cost)?

g. Which financing option should you choose? Explain in words right on the spreadsheet you have used to determine these values.

Reference no: EM131561528

Questions Cloud

What is the optimal time for anaconda to sell the mine : Anaconda Manufacturing Company currently owns amine that is known to contain a certain amount of gold. what is the optimal time for Anaconda to sell the mine?
To what extent must criminal trials be open to the public : To what extent must criminal trials be open to the public? Which of the following most accurately describes how to read a statute?
What type of business organization should they change to : Jackie, Jennifer and Jesse are active members of a Texas general partnership called "Swim City". The Houston-based partnership manufactures, sells and installs.
Examine the relationship between age and self-disclosure : An experimenter is examining the relationship between age and self-disclosure. A large sample of participants that are 25 to 35 years old and participants.
What is the amount of money that you will need to borrow : Get $3,000 cash back. This amount will reduce the amount you need to finance. What is the amount of money that you will need to borrow under Option 1
Capital structure without issuing additional share of equity : Assuming there is sufficient cash flow for Tysseland to maintain its target capital structure without issuing additional shares of equity,
Describe the physical configuration of the eoc : Describe the physical configuration of the EOC. Describe any alternative operating facilities that have been identified.
What are the three frameworks of the triple bottom line : Your essay should be at least two pages in length, double-spaced, and in 12 pt. Times New Roman font. The title and reference pages do not count towards.
How the principles are integrated into the functions : Reflect on how these principles are integrated into the functions of Emergency Operation Centers and multiagency coordination systems.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Theory of interest - term structure of interest rates

Term Structure of Interest Rates

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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