loan problem

Project: Dan Gets A Loan a Construct a table for the following loan problem: Assume $10,000 is owed at an interest rate of eight percent per year, compounded monthly. Produce a table with the following data: Column A = month Column B = Amount due at month A with monthly payments of 100 Columns C, D, E involve payments of 150, 200, & 300. The final spreadsheet should look like: Month Loan at $100 Loan at $150 Loan at $200 Loan at $300 0 $10,000 $10,000 $10,000 $10,000 1 10K+interest-100 10K+inter.-150 10K +inter-200 2 prev.+interest-100 prev+inter-150 3 prev.+interest-100 prevtinter-150 ... ** Keep computing in each column until no money is owed in each column. Trick: Use relative-addresses. $9966.66 should be your first value