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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!