70.2K

Verified Solution

Link Copied!

in python preferably

(10 Marks) 1. Using Microsoft Excel, OpenOffice Calc or Google Sheets, create a spreadsheet using the banking data and steps below. Account # Balance ($) Interest (%) 10020 11930.39 1.5 10067 25670.01 1.65 10093 5610.44 0.95 10124 51410.25 1.85 10129 10651.32 1.5 (a) Create a column "2024 Balance" (of real values) of the forecast balance of each of the accounts after 2 years, where the balance of each account receives yearly compound interest at the rate given by "Interest". (b) Create a column "2027 Balance" (of real values) of the forecast balance of each of the accounts after 5 years, where the (original) balance of each account receives yearly compound interest at the rate given by "Interest". (c) Create a column "Minimum Balance" (of real values) of the minimum balance of each the accounts below which a charge is incurred, where the minimum balance is 55% of the (original) balance if the balance is less than or equal to $15000 and 37.5% of the balance otherwise. Create a row Totals" (of real values of the totals of the 5 columns "Balance", "Interest", "2024 Balance","2027 Balance" and "Minimum Balance". (d) (e) Create a row "Averages" (of real value) of the averages of the 5 columns "Balance", Interest", "2024 Balance","2027 Balance" and "Minimum Balance". Your submission is to be a spreadsheet (.xls, .xlsx, .ods,...)

Answer & Explanation Solved by verified expert

See Answer