You just graduated college with your Bachelors Degree and accepted a job offer at your dream...

You just graduated college with your Bachelors Degree and accepted a job offer at your dream company. You decided to celebrate by purchasing the vehicle of your dreams. Pictured is a Dodge Challenger HellCat see picture above for $58,995). You have a 720 credit score, therefore you were able to get a 5% interest rate on a 7 year loan. You will be making monthly payments. Using Excel, prepare a professional amortization schedule for the entire 7 years. It must include the payment and the total amount of interest you will pay over the 7 years. (Hint: interest rates are annual, you must convert them to monthly and the periods must be in months, for example, how many months are in 7 years) . The Excel cells must contain formulas when appropriate, I recommend cell referencing, both relative and absolute.

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Assume you just accepted a new job offer and you are negotiating your contract. You are...

Assume you just accepted a new job offer and you are negotiating your contract. You are offered the opportunity to take deferred salary. Would you accept this offer? Why or why not? If not, under what circumstances would you consider accepting a deferred salary? If you were the owner of a business, would you want to pay your employees a deferred salary? Why or why not?

Suppose you have just graduated Harvard and accepted a job with a $100,000 salary. Your 401(K)...

Suppose you have just graduated Harvard and accepted a job with a $100,000 salary. Your 401(K) will be maxed at 5% employee contribution and 1-1 employer match. You will work for exactly the next 45 years (for simplicity assume your salary is unchanged). At your 5 year review you will receive a one-time $20,000 bonus which you will deposit in your retirement plan. You will live exactly 25 years after you retire. You plan to leave $200,000 to Harvard to...

You just graduated from college and are starting your new job. You realized the importance to...

You just graduated from college and are starting your new job. You realized the importance to save for the future and have figured out that you will save $2,000 per month for the next 14 years; and then increase to $6,000 per month for the following 6 years. The amount accumulated at the end of these investments will be your retirement egg nest. You plan to start retirement and start withdrawing monthly amounts the following month (you will be in...

You just graduated from college and are starting your new job. You realized the importance to...

You just graduated from college and are starting your new job. You realized the importance to save for the future and have figured out that you will save $1,000 per month for the next 14 years; and then increase to $5,000 per month for the following 5 years. The amount accumulated at the end of these investments will be your retirement egg nest. You plan to start retirement and start withdrawing monthly amounts the following month (you will be in...

You have just turned 22 received your degree and accepted your first job. You must decide...

You have just turned 22 received your degree and accepted your first job. You must decide how much to put in your retirement plan. The plan works as follows. Every dollar in the plan earns 6.5 percent per year. You may not make withdrawals until you retire at 65. After that you can withdrawal money as needed. You believe you will live to 100 and work until 65, and believe you need 95000 per year to be comfortable starting at...

Grady Zebrowski, age 25, just graduated from college, accepted his first job with a $45 comma...

Grady Zebrowski, age 25, just graduated from college, accepted his first job with a $45 comma 000 salary, and is already looking forward to retirement in 40 years. He assumes a 3.5 percent inflation rate and plans to live in retirement for 20 years. He does not want to plan on any Social Security benefits. Assume Grady can earn a 6 percent rate of return on his investments prior to retirement and a 6 percent rate of return on his...

Grady Zebrowski, age 25, just graduated from college, accepted his first job with a $47,000 salary,...

Grady Zebrowski, age 25, just graduated from college, accepted his first job with a $47,000 salary, and is already looking forward to retirement in 40 years. He assumes a 2.1 percent inflation rate and plans to live in retirement for 20 years. He does not want to plan on any Social Security benefits. Assume Grady can earn a 9 percent rate of return on his investments prior to retirement and a 5 percent rate of return on his investments post-retirement...

You have just turned 22 years old, received your bachelor's degree, and accepted your first job....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 7% per year. You cannot make withdrawals until you retire on your 65th birthday. After that, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn 65....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 6.9 % per year. You cannot make withdrawals until you retire on your 65th birthday. After that, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn...

You have just turned 22 years old, received your bachelor's degree, and accepted your first job....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 6.7 % per year. You cannot make withdrawals until you retire on your 65th birthday. After that, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn...

Subjects