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 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
Get step-by-step solutions from verified subject matter experts
