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
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
Chapter 4, Question 1.
arrow_forward
ces
You have a choice of four increasing annuities as shown in the table below. Which annuity will reach a future value of $100,000 the earliest?
Annuity B
Annuity C
$1100
Annuity D
$800
$57
8%
3%
52
1
Payment
Annual Rate
Interest Periods
Per Year
Annuity A
$300
5%
12
(Use the interactive figure to find your answer.)
Click here to launch the interactive figure.
Choose the correct answer below.
OA. Annuity D
OB. Annuity A
OC. Annuity B
OD. Annuity C
9%
4
چلے
i, 14e
gin MLM
Incorrec
arrow_forward
Please correct only or skip please and both or skip pls, dont do handwritten
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
ss
arrow_forward
QUESTION 14
What’s the interest rate of a 8-year, annual $3,500 annuity with present value of $20,000? (Use a time value of money calculator or a spreadsheet. Round your answer to 2 decimal places.)
ANNUITY INTEREST RATE %
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
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
QUESTION 1
Considering the following scenario. In years 0, 2, 4, 6, and 8, you deposit $750 in your savings account. The saving
account earns 4.25% compounded anbually. What is the future value in year 10?
4,847.22
5,411.56
3,579.94
6,411.56
arrow_forward
Problem 5.06 (Future Value: Annuity Versus Annuity Due)
eBook
What's the future value of an 11%, 5-year ordinary annuity that pays $400 each year? If this was an annuity due, what would its future value be? Do not round
intermediate calculations. Round your answers to the nearest cent.
Future Value of an Ordinary Annuity: $
Future Value of an Annuity Due: $
arrow_forward
Question 7 of 10
>
Every year you deposit $3,400 into an account that earns 2% interest per year. What will be the balance of your account immediately after the 20th deposit?
Click the icon to view the interest and annuity table for discrete compounding when i = 2% per year.
Choose the correct answer below
O A. $79,464
O B. $68,000
OC. $82,611
OD. $51,438
O E $84,263
arrow_forward
Future and present value of an annuity Find the future and present value of a 20-year ordinary annuity paying $500.00 per year at each of the following interest rates: a, 20% h 10% c 1% d 0.1% e. What is the general principle that you see when you compare your answers here? What value are both the present value and future value getting close to as you move from part a to part d?
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
How much money must an electrical contractor deposit every year in her savings account starting 1 year from now at 7.5% peyear in order to accumulate $9000 five years from now?Select one:O a. 49620Ob. 1290O c.726d.1549Oe.52290Clear my choice
Please answer fast please arjent
arrow_forward
Future value of an annuity Using the values below, answer the questions that follow. (Click on the icon here 9 in order to copy the contents of the data table below into a spreadsheet.)
Amount of annuity
Interest rate
Deposit period (years)
$6,000
8%
10
a. Calculate the future value of the annuity, assuming that it is
(1) An ordinary annuity.
(2) An annuity due.
b. Compare your findings in parts a(1) and a(2). All else being identical, which type of annuity-ordinary or annuity due-is preferable as an investment? Explain why.
.....
a. (1) The future value of the ordinary annuity is $
(Round to the nearest cent.)
(2) The future value of the annuity due is $
(Round to the nearest cent.)
b. Compare your findings in parts a(1) and a(2). All else being identical, which type of annuity is preferable as an investment? (Select the best answer below.)
Ordinary annuity, because it yields a greater future value.
Annuity due, because it yields a greater future value.
arrow_forward
how do I do this on the financial calculator?
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
9
arrow_forward
posit at the end of
hat
year 3?
p5-19 Future value of an annuity For each case in the accompanying table, answer the
questions that follow.
Case
Amount of annuity Interest rate Deposit period (years)
A.
$ 2,500
8%
10
S00
12
30,000
20
D.
11,500
8.
E
6,000
30
a. Calculate the future value of the annuity, assuming that it is
(1) An ordinary annuity.
(2) An annuity due.
h Compare your findings in parts a(1) and a(2). All else being identical, which type
able? Explain why.
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
Please answer part d using formula without using excel
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_forwardChapter 4, Question 1.arrow_forwardces You have a choice of four increasing annuities as shown in the table below. Which annuity will reach a future value of $100,000 the earliest? Annuity B Annuity C $1100 Annuity D $800 $57 8% 3% 52 1 Payment Annual Rate Interest Periods Per Year Annuity A $300 5% 12 (Use the interactive figure to find your answer.) Click here to launch the interactive figure. Choose the correct answer below. OA. Annuity D OB. Annuity A OC. Annuity B OD. Annuity C 9% 4 چلے i, 14e gin MLM Incorrecarrow_forward
- Please correct only or skip please and both or skip pls, dont do handwrittenarrow_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_forwardssarrow_forward
- QUESTION 14 What’s the interest rate of a 8-year, annual $3,500 annuity with present value of $20,000? (Use a time value of money calculator or a spreadsheet. Round your answer to 2 decimal places.) ANNUITY INTEREST RATE %arrow_forwardQuestion 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_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_forwardQUESTION 1 Considering the following scenario. In years 0, 2, 4, 6, and 8, you deposit $750 in your savings account. The saving account earns 4.25% compounded anbually. What is the future value in year 10? 4,847.22 5,411.56 3,579.94 6,411.56arrow_forwardProblem 5.06 (Future Value: Annuity Versus Annuity Due) eBook What's the future value of an 11%, 5-year ordinary annuity that pays $400 each year? If this was an annuity due, what would its future value be? Do not round intermediate calculations. Round your answers to the nearest cent. Future Value of an Ordinary Annuity: $ Future Value of an Annuity Due: $arrow_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