Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Exchange Rates And Financial Flows In The International Financial System

Authors: Heather D. Gibson

1st Edition

0582218128, 978-0582218123

More Books

Students also viewed these Finance questions

Question

What Makes Machine Learning Projects Unique in HR

Answered: 1 week ago

Question

5.2 Summarize the environment of recruitment.

Answered: 1 week ago