Exponential Modeling: Simple and Compound Interest
Not what you're looking for?
1) Create an Excel spreadsheet comparing simple and interest compounded yearly for an investment of $18,000 over 18 years with an APR of 3.75%.
a. Create a column in Excel listing the years 0-18.
b. Determine the equation that would model simple interest. Hints: How much simple interest would the account earn each year? What type of equation is appropriate for simple interest? Create a column of values that represents the accounts balance for each year if only simple interest is earned.
c. Determine the equation that would model compound interest. Hints: What type of equation is appropriate for compound interest? Create a column of values that represents the accounts balance for each year if the interest is compounding each year.
d. Use the data from the spreadsheet to create a single graphic (scatterplot) comparing the two types of interest.
e. Write a paragraph which includes a compare and contrast of simple and compound interest, based upon your graphic.
Purchase this Solution
Solution Summary
The Excel file contains the computations and graph. The Word file contains the solutions to the questions.
Solution Preview
A
Please see the Excel file.
B
The equation is I=Prt
I = 18000 * 0.0375 * 1 = 675
The account would earn $675 simple interest per year.
The ...
Education
- MSc, California State Polytechnic University, Pomona
- MBA, University of California, Riverside
- BSc, California State Polytechnic University, Pomona
- BSc, California State Polytechnic University, Pomona
Recent Feedback
- "Excellent work. Well explained."
- "Can you kindly take a look at 647530 and 647531. Thanks"
- "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
- "GREAT JOB!!!"
- "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Motivation
This tests some key elements of major motivation theories.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.