Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. show work (excel if possible but show formulas you

Show work (excel if possible but show formulas you used in excel): If I buy a new...

70.2K

Verified Solution

Question

Finance

Show work (excel if possible but show formulas you used inexcel):

If I buy a new car and pay $399 a month for 5 years and themaintenance costs are $50 the first year and increase by $200 ayear for each year after that, how much money would I have tobarrow today at a nominal interest rate of 9% to cover my monthlypayment and my yearly maintenance bill?

Answer & Explanation Solved by verified expert
4.3 Ratings (566 Votes)
Amount to be borrowed today Present value of monthlypayments Present value of yearly maintenance costsFinding present value of monthly payments discounted atmonthly rateMonthly payment 399 No of payments or months 12 x No ofyears 12 x 5 60 Nominal interest rate 9Monthly rate    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

“Before there was Paris Hilton, there was Consuelo VanderbiltBalsan – a Gilded Age heiress...

Accounting
Q

JAVA Add static methods largest and smallest to the Measurable interface. The methods should return the object...

Programming
Q

Question (2) Which of the following histology stains is/are used to highlight glycosaminoglycans in tissue sections Alcian...

Biology
Q

The uniform line charge density extends over entire ring λ=1.96E-6 C/m Mass of ring M=0.13 kg....

Physics
Q

Which of the following is not true regarding viruses Viruses are filterable agents Viruses are...

Biology
Q

4 Modern hard drives spin very fas called the platter Assume an aluminum platter that...

Physics
Q

Let A = A is a 4X4 matrix . Show that A is invertible by...

Algebra
Q

Barb owns all 100 shares of Lattice Corporation stock having a $ 0.85 million FMV....

Accounting
Q

John and Ellen Brite are married, file a joint return, and are less than 65...

Accounting
Q

MAGIC CARPETS BEGAN THE YEAR WITH INVENTORY OF $1,400,000. iNVENTORY PURCHASES FOR THE YEAR TOTALLED...

Accounting
Q

Identify the internal control principle below with the appropriate cash receipts procedure described. ...

Accounting
Q

Window company had sales of $800,000 into 2016 the company expects to incur warrantee expenses...

Accounting