I’m working on a Accounting question and need guidance to help me study.

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 (think big, for this class’s sake. Pictured is a Mercedes Convertible see picture above for $67,300). 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.

Present two additional amortization schedules using 6% and 7%. And be prepared to answer the following questions:

What happens to the total cost for the car (principle and interest) when the interest is increased by only 1 or 2 percent?

What do you think about the reverse side of this, that is to say, receiving this type of interest payments for loaning money to others for these interest rates?

Lastly, indicate if you would purchase a vehicle that costs this much, and why.

Hi Sir 

I have project that due on Sunday. 

1.                   The Work/Accumulation period

•                      The retirement spreadsheet should calculate on a year by year basis the accumulation of retirement savings. This means you will have a series of time value of money calculations. Each year will therefore be a future value calculation for the year. You must state for each year the proportion of your portfolio you want to invest in equities (with an expected return of xx%) vs. bonds (with an expected return of aa%)

•                      Assume annual contributions are split into equal monthly installments made at the end of each month, coincident with the receipt of your paycheck.

•                      For simplicity, assume your account compounds on a monthly basis.

•                      Repeat the calculation for each year you are working to determine your account balance at retirement.

2.                   The Retirement/Spending Period

•                      In your first year of retirement, there will be no further cash inflows into the retirement account. Since you are no longer working, you are only drawing from the principal you have accumulated and not earning a salary. Your job is to calculate how much money will be left in your account at the end of the year after drawing out your retirement income. Remember, your principal will still earn the risk-free rate of return of ww%. You aren’t pulling out all the money at once. The annual draw on your savings will  (a) be split into equal monthly withdrawals, (b) should be based on your budget and (c) be reported in the “withdrawal” column.

•                      Continue the calculation for future years. Increase your withdrawal each year by 2.1% so your retirement income keeps pace with inflation. Remember, your principal will still be earning the risk-free rate of interest.

3.                   Results

•                      Report how old you are when (or if) you run out of money. Were your savings sufficient to fund your retirement until your expected date of death?  Based on this analysis, would you change anything about either your pre-retirement contributions or your post-retirement withdrawal patterns?  Would you change your asset mix? 

•                      Make appropriate changes to your assumptions to ensure that your retirement income lasts to age 100. Once you have a retirement plan that you are comfortable with, we will use that for the third part of the assignment

read all matirials I gave to you carefully. Do your best. 

read all matirials I gave to you carefully. Do your best.