Question: Your task is to create an excel spreadsheet that will serve as a calculator for the finance chapter. Your spreadsheet should be able to take

Your task is to create an excel spreadsheet that will serve as a calculator for the finance chapter. Your spreadsheet should be able to take specific values of the variables and calculate a missing value. Specifically, your calculator should be able to perform all the following: 1. Simple interest A Given Principle, rate and time determine the simple interest earned B Given Principle, rate and time determine the future value of the account C Given the future value, rate, and time, determine the principal value of the account D Given Principle, Future value and rate determine the amount of time that has passed E Given Principle, Future value and time determine the simple interest rate 2. Compound interest A Given principle, rate, time, and number of compounds determine the future value B Given future value, rate, time, and number of compounds determine the principle value C Given rate and number of compounds determine the APY (annual percentage yield) 3. Increasing annuity A Given a payment, rate, time, and payment period determine the future value B Given the future value, rate, time, and payment period, determine the payment C Determine the total amount deposited into the account over time D Determine the total interest earned from the account over time 4. Decreasing annuity A Given a present value, rate, time, and payment period determine the payment B Given the payment, rate, time, and payment period, determine the maximum purchase price C Determine the total amount deposited into the account over time D Determine the total interest earned from the account over time
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
