Question: 1. Create a spreadsheet that will function as an Investment and Loan Calculator. Users should be able to input the following variables and receive the

 1. Create a spreadsheet that will function as an "Investment and

1. Create a spreadsheet that will function as an "Investment and Loan Calculator." Users should be able to input the following variables and receive the future value of their investment or Ioan. (One simple and one compound.) - Initial Investment/Loon Amount (Principal) - Interest Pate (Compounded Yearly) - Number of Years invested Use color and layout to personalize your "calculator." 2. Create a "How This Calculator Works" explanation. This can be done in the spreadsheet or on this document or a sheet of paper. Your explanation should include: - A description of the differences between simple and compound interest - Tables that show how compound interest and simpve interest is calculated (over a few years) - An explanation why your formulas work in finding future value for any number of years (why does compound interest have an expanent, and simple interest doesn't). - Any other connections between the situotion, tabie, graph, and rule. "How This Calculator Works" IType work here or in your spreadsheet. If you do your work on paper, submit photos of the work herel

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!