FINA310 Unit 3 IP Assignment
docx
keyboard_arrow_up
School
American InterContinental University *
*We aren’t endorsed by this school
Course
310
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
5
Uploaded by ChefJellyfishMaster4675
1
Tishay Lawrence
FINA310
Instructor: J Bruce Parker Date: December 16, 2023
1
Page 1: Introduction
Based on the first scenario:
Answer the following question utilizing the
Future Value of an Annuity calculator
:
If Sally’s account compounds monthly, calculate how much Sally will have in her savings account:
1.
In 1
Future Value (FV) of the Ordinary Annuity
$ 36,589.21
Total Interest
$12,589.21
Total Payments
$24,000.00
0 years?
2.
In 20 years?
$ 117,804.08
Total Interest
$69,804.08
Total Payments
$48,000.00
3.
In 30 years?
$ 298,071.89
Total Interest
$226,071.89
Total Payments
$72,000.00
1
4.
In 40 years?
$ 698,201.57
Total Interest
$602,201.57
Total Payments
$96,000.00
Page 2: Based on the second scenario:
Answer the following questions utilizing the
Credit Card Interest Calculator
:
1.
For just one year of spending $100 on dinner every other Saturday, how much would Debbie pay in interest for her credit card balance of $2,400? ( 20%) 2. It will take
9 years and 1 month
to payoff the balance. The total interest is
$2,803.15
.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
1
3.
How long would it take for Debbie to payoff this debt with a minimum payment of $48 per month? (18 %)
It will take
7 years and 10 months
to payoff the balance. The total interest is
$2,069.33
.
4.
How would her interest rate change if she had a better credit score rating?
With super prime her rate would go from 20% to 18% with a better credit score Page 3
For more information about interest rates, please review this article regarding
credit score ratings
.
1.
Were you surprised at the results?
2.
What lessons did you learn from these calculations?
1
3.
What changes may you make in your personal finances based on the knowledge of time value of money principles?
Conclusion: Add references and ensure that they are in APA format!
REFERENCES:
Related Documents
Related Questions
ook
ences
Chris Seals has just given an insurance company $62,525. In return, she will receive an annuity of $7,458 for 12 years.
a. At what rate of return must the insurance company invest this $62,525 to make the annual payments? (Use a Financial
calculator to arrive at the answers. Round the final answer to 3 decimal places.)
Rate of return
b. What rate of return is required if the annuity is payable at the beginning of each year? (Use a Financial calculator to arrive at
the answers. Round the final answer to 2 decimal places.)
Rate of return
arrow_forward
Excel Online Activity: Required annuity payments 1
Question 1
0/10
Submit
HVideo
Excel Online Structured Activity: Required annuity payments
Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income
that has the same purchasing power at the time he retires as $60,000 has today. (The real value of his retirement income will decline annually after he
retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual
inflation is expected to be 4%. He currently has $70,000 saved, and he expects to earn 9% annually on his savings. The data has been collected in the
Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.
Qoen spreadsheet
How much must he save during each of the next 10 years (end-of-year deposits) to meet his retirement goal? Do…
arrow_forward
If you owe $47,000 payable at the end of five years, what amount should your creditor accept in payment immediately ifse cou
earn 8 percent on her money? Use Appendix B for an approximate answer, but calculate your final answer using the formula and
financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
Présent value
eBook
Hint
ant
Reterenc
PV=F
47,0
arrow_forward
Question Help ▼
You plan to deposit $800 in a bank account now and $500 at the end of the year. If the account earns 3% interest per year, what will be the balance in the account right after you make the second
deposit?
The balance in the account right after you make the second deposit will be $
(Round to the nearest dollar.)
Enter your answer in the answer box.
arrow_forward
Suppose you want to have $700,000 for retirement in 20 years. Your account earns 7% interest.
a) How much would you need to deposit in the account each month?
b) How much interest will you earn?
S
Question Help: Video
Submit Question
Q Search
hp
H
arrow_forward
QUESTION 5
Katharine Bartle will receive an annuity of $4,090.00 every month for 23 years. How much is this cash flow worth to them today if the
payments begin today? Assume a discount rate of 5.00%.
Oa. $55,398.13
b. $2,119,880.47
c. $672,837.73
Od. $170,156.69
arrow_forward
Question Help
Acme Annuities recently offered an annuity that pays 4.2% compounded monthly. What equal monthly deposit should be made into this annuity in order to have $70,000 in
10 years?
The amount of each deposit should be $.
(Round to the nearest cent.)
Enter your answer in the answer box and then click Check Answer.
Clear All
Check Answer
All parts showing
ר
arrow_forward
First Time Value of Money Homework i Help Save & Exit Submit 13 Mary is going to receive a 31-year annuity of $9,600 per year. Nancy is going to receive a perpetuity of $9,600 per year. If the appropriate interest rate is 9 percent, how much more is Nancy's cash flow worth? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. 10 Present value Book Prent Reterences: Present value
arrow_forward
You want to be able to withdraw $30,000 from your account each year for 30 years after you retire.
You expect to retire in 20 years.
If your account earns 8% interest, how much will you need to deposit each year until retirement to achieve
your retirement goals?
Question Help: DVideo 1 D Video 2
Submit Question
arrow_forward
Finance
Find the savings plan balance after 18 months with an APR of 6% and monthly payments of $800. Assume an ordinary annuity. a. $15,028.63 c. $15,360.28 b. $15,280.36 d. $15,306.82 Please select the best answer from the choices provided A B C D
arrow_forward
QUESTION 43
A student wants save for college which begins in five years. How much will the student save assuming equal deposits of $2,500 at the beginning of each year and 4% interest? Following are appropriate factors from tables:
Table
% / n
Present Value of annuity due $1
Present Value of ordinary annuity of $1
Future value of annuity due $1
Future Value of ordinary annuity of $1
4%/5
4.62990
4.45182
5.63298
5.41632
$11,574.75
$13,540.80
$14,082.45
$11,129.55
arrow_forward
Intro
You decided to save $1,400 every year, starting one year
from now, in a savings account that pays an annual
interest rate of 5%.
Part 1
74440
How many years will it take until you have $100,000 in
the account?
1+ decimals
Submit
arrow_forward
Part 1: Data Tables
You have decided to start saving for retirement. You plan to work for 35 years and then retire.
Requirements: Complete each requirement on a separate worksheet.
1. Calculate the amount of money that will be in your Roth IRA account when you retire if
you:
a. Save $3,500 at the end of each year.
b.
Earn 7% interest each year.
c. The answer to requirement I must be calculated using a single formula.
2. Create a one-input Data Table that calculates the value of your Roth IRA when you retire
if the annual savings amount is different than $3,500 per year.
a. Use the following annual end of the year annual savings amounts as the column
data in the Data Table: $500, $1,000, $2,000, $3,000, $3,500, $4,000, and $5,000.
b. The annual interest rate is still 7% each year.
3. Create a two-input Data Table that calculates the value of your Roth IRA when you retire
for different annual interest rates and different annual savings amounts.
a. Use the following annual interest rates…
arrow_forward
question 1
arrow_forward
Calculate the principal portion of the second payment on the required on an amortized loan
annual interest rate of 8.25% for 20 years.
finance the purchase of a new home priced at $99,757.57 assuming the
O A. $165.30
O B. $174.17
OC. $175.30
O D. $164.17
Click to select your answer.
tUs /-
MacBook Air
888
F4
14
F7
F1
F3
FS
F6
II
4)
F9
F10
F11
@
2$
4
23
&
2
6.
0.
R
Y
P.
S
D
F
H.
J
K
B
alt
command
+
arrow_forward
can you help me with accounting question
arrow_forward
help me with this Practice problem
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- ook ences Chris Seals has just given an insurance company $62,525. In return, she will receive an annuity of $7,458 for 12 years. a. At what rate of return must the insurance company invest this $62,525 to make the annual payments? (Use a Financial calculator to arrive at the answers. Round the final answer to 3 decimal places.) Rate of return b. What rate of return is required if the annuity is payable at the beginning of each year? (Use a Financial calculator to arrive at the answers. Round the final answer to 2 decimal places.) Rate of returnarrow_forwardExcel Online Activity: Required annuity payments 1 Question 1 0/10 Submit HVideo Excel Online Structured Activity: Required annuity payments Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $60,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual inflation is expected to be 4%. He currently has $70,000 saved, and he expects to earn 9% annually on his savings. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Qoen spreadsheet How much must he save during each of the next 10 years (end-of-year deposits) to meet his retirement goal? Do…arrow_forwardIf you owe $47,000 payable at the end of five years, what amount should your creditor accept in payment immediately ifse cou earn 8 percent on her money? Use Appendix B for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Présent value eBook Hint ant Reterenc PV=F 47,0arrow_forward
- Question Help ▼ You plan to deposit $800 in a bank account now and $500 at the end of the year. If the account earns 3% interest per year, what will be the balance in the account right after you make the second deposit? The balance in the account right after you make the second deposit will be $ (Round to the nearest dollar.) Enter your answer in the answer box.arrow_forwardSuppose you want to have $700,000 for retirement in 20 years. Your account earns 7% interest. a) How much would you need to deposit in the account each month? b) How much interest will you earn? S Question Help: Video Submit Question Q Search hp Harrow_forwardQUESTION 5 Katharine Bartle will receive an annuity of $4,090.00 every month for 23 years. How much is this cash flow worth to them today if the payments begin today? Assume a discount rate of 5.00%. Oa. $55,398.13 b. $2,119,880.47 c. $672,837.73 Od. $170,156.69arrow_forward
- Question Help Acme Annuities recently offered an annuity that pays 4.2% compounded monthly. What equal monthly deposit should be made into this annuity in order to have $70,000 in 10 years? The amount of each deposit should be $. (Round to the nearest cent.) Enter your answer in the answer box and then click Check Answer. Clear All Check Answer All parts showing רarrow_forwardFirst Time Value of Money Homework i Help Save & Exit Submit 13 Mary is going to receive a 31-year annuity of $9,600 per year. Nancy is going to receive a perpetuity of $9,600 per year. If the appropriate interest rate is 9 percent, how much more is Nancy's cash flow worth? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. 10 Present value Book Prent Reterences: Present valuearrow_forwardYou want to be able to withdraw $30,000 from your account each year for 30 years after you retire. You expect to retire in 20 years. If your account earns 8% interest, how much will you need to deposit each year until retirement to achieve your retirement goals? Question Help: DVideo 1 D Video 2 Submit Questionarrow_forward
- Finance Find the savings plan balance after 18 months with an APR of 6% and monthly payments of $800. Assume an ordinary annuity. a. $15,028.63 c. $15,360.28 b. $15,280.36 d. $15,306.82 Please select the best answer from the choices provided A B C Darrow_forwardQUESTION 43 A student wants save for college which begins in five years. How much will the student save assuming equal deposits of $2,500 at the beginning of each year and 4% interest? Following are appropriate factors from tables: Table % / n Present Value of annuity due $1 Present Value of ordinary annuity of $1 Future value of annuity due $1 Future Value of ordinary annuity of $1 4%/5 4.62990 4.45182 5.63298 5.41632 $11,574.75 $13,540.80 $14,082.45 $11,129.55arrow_forwardIntro You decided to save $1,400 every year, starting one year from now, in a savings account that pays an annual interest rate of 5%. Part 1 74440 How many years will it take until you have $100,000 in the account? 1+ decimals Submitarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning