1. Using Microsoft Excel, OpenOffice Calc or Google Sheets, create a spreadsheet using the bank data...

Transcribed Image Text:

1. Using Microsoft Excel, OpenOffice Calc or Google Sheets, create a spreadsheet using the bank data below and following steps. (Yearly) interest is applied to a balance. A surcharge is applied to each balance after interest. Client Balance ($) Interest (%) Surcharge ($) Jerry 1602 5.5 80 Xiao 29013 1.9 120 Hector 7542 4.25 75 Angela 7433 3.33 55 Lori 100949 2.25 220 Create a column "Y1" of the forecast balance of each of the clients after 1 year, where each client earns (1 year of) compound interest, but is deducted a surcharge (after interest). (a) (b) Create a column "Y2" of the forecast balance of each of the clients after 2 years, where each client earns (2 years of) compound interest (but no surcharge is deducted). (c) Create a column "Y5" of the forecast balance of each of the clients after 5 years, where each client earns (5 years of) compound interest (but no surcharge is deducted). (d) Create a column "Crash Balance" of the balance of each of the clients after a stock market crash, a value equal to 75% of the original balance if that original balance is equal to or more than $60,000 and 47.5% otherwise. (e) Create a column "Y1-3" of the forecast balance of each of the clients 3 years after the crash (using the "Crash Balance" rather than the original balance), where each client still earns (3 years of) compound interest, but is deducted only 85% of the surcharge (after interest). (f) Create a row "Totals" of the totals of each of the numerical (not "Client") columns. (g) Create a row "Means" of the averages of each of the numerical (not "Client") 1. Using Microsoft Excel, OpenOffice Calc or Google Sheets, create a spreadsheet using the bank data below and following steps. (Yearly) interest is applied to a balance. A surcharge is applied to each balance after interest. Client Balance ($) Interest (%) Surcharge ($) Jerry 1602 5.5 80 Xiao 29013 1.9 120 Hector 7542 4.25 75 Angela 7433 3.33 55 Lori 100949 2.25 220 Create a column "Y1" of the forecast balance of each of the clients after 1 year, where each client earns (1 year of) compound interest, but is deducted a surcharge (after interest). (a) (b) Create a column "Y2" of the forecast balance of each of the clients after 2 years, where each client earns (2 years of) compound interest (but no surcharge is deducted). (c) Create a column "Y5" of the forecast balance of each of the clients after 5 years, where each client earns (5 years of) compound interest (but no surcharge is deducted). (d) Create a column "Crash Balance" of the balance of each of the clients after a stock market crash, a value equal to 75% of the original balance if that original balance is equal to or more than $60,000 and 47.5% otherwise. (e) Create a column "Y1-3" of the forecast balance of each of the clients 3 years after the crash (using the "Crash Balance" rather than the original balance), where each client still earns (3 years of) compound interest, but is deducted only 85% of the surcharge (after interest). (f) Create a row "Totals" of the totals of each of the numerical (not "Client") columns. (g) Create a row "Means" of the averages of each of the numerical (not "Client")

Answer rating: 100% (QA)

Y1 Y2 Y5 Crash Bal Y13 161011 178783 210776 76095 82912 2944424 30135... View the full answer