Google spreadsheet or excel

6. Valley Rendering, Inc. is considering purchasing a new otation system for grease recovery. The company can finance a $150,000 system at 5% per year compound interest or 5.5% per year simple interest. If the total amount owed is due in a single payment at the end of 3 years, (a) which interest rate should the company select, and (bi how much is the difference in interest between the two schemes? 7. Fill in the missing values (A through D) for a loan of $10,000 if the interest rate is compounded at 10% per year. End of Interest Amount Owed End of Year Amount Owed Year for Year After Interest Payment After Payment n -m --_-_ 8. For each statement, identify the compounding period, the payment period, and the type of interest rate (nominal or effective}, then express each rate as an effective annual, and monthly rate. 8% per year 2.5% per quarter 8.5% compounded monthly 6.8% quarterly, compounded monthly 2% per month, compounded weekly 1% per week prop-99's 9. Ford Motor Company is considering an early retirement buyout package for some employees. The package involves paying out today's fair value of the employee's nal year of salary. Shelby is due to retire in one year. Her salary is at the company maximum of $72,000. If prevailing interest rates are 6.75% compounded monthly, what buyout amount should Ford offer to Shelby today? 10. Exactly how long will it take for your money to quadruple at 6.54% compounded monthly