W04 Study & Quiz_ IRA_ Personal Finance
pdf
keyboard_arrow_up
School
Brigham Young University, Idaho *
*We aren’t endorsed by this school
Course
433
Subject
Finance
Date
May 30, 2024
Type
Pages
8
Uploaded by ConstableAlpacaMaster973
W04 Study & Quiz: IRA
Due May 16 at 11:59pm
Points 20
Questions 20
Available after May 4 at 12am
Time Limit None
Instructions
Task:
Study these materials
about IRAs and then take a quiz
.
Purpose:
Understand the definition and power of IRAs.
Instructions
1. Complete the readings:
Traditional IRA
(http://www.investopedia.com/university/retirementplans/ira/) (Five sections)
ROTH IRA
(http://www.investopedia.com/university/retirementplans/rothira/) (Five sections)
Roth 401(k) Fact Sheet
(https://byui.instructure.com/courses/294268/pages/roth-401-k-fact-sheet)
SIMPLE IRA
(http://www.investopedia.com/university/retirementplans/simpleira/) (Five
sections)
SEP IRA
(http://www.investopedia.com/university/retirementplans/sepira/) (Five sections)
Coverdell ESA
(http://www.investopedia.com/university/retirementplans/esa/) (Four sections)
529 College Savings Plan
(http://www.investopedia.com/university/retirementplans/529plan/)
(Six sections)
IRA Fact Sheet
(https://byui.instructure.com/courses/294268/files/128080304?wrap=1) (https://byui.instructure.com/courses/294268/files/128080304/download?download_frd=1)
Millionaire Next Door: The Surprising Secrets of America's Wealthy
(https://ebookcentral.proquest.com/lib/byui/detail.action?docID=867833) NOTE
: Taking notes during
this reading assignment will help you as you create a summary of concepts at the end of the
semester.
2. View the video or PowerPoint:
IRA and other forms of tax-advantaged savings accounts
(https://video.byui.edu/media/B433_L04_IRA/0_lbbs2o23) (11:14 mins, "IRA and other forms of
Tax-Advantage Savings Accounts" Transcript
(https://docs.google.com/document/d/e/2PACX-1vTLHI-5L-
9vHDjuvwWLCeCZU8KKGWrB20HLE8orusCyPR2woihlUnt0j5fP4G3N33IkDN3JnLjj_LRN/pub) )
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
1/8
Attempt History
Attempt
Time
Score
LATEST
Attempt 1
22 minutes
14 out of 20
Correct answers will be available on May 17 at 12am.
Score for this quiz: 14 out of 20
Submitted May 15 at 6:45pm
This attempt took 22 minutes.
Question 1
1 / 1 pts
taxable income
tax-free income
tax-deferred income
earned income
0:00
/ 9:03
1x
1x
(09:03, "IRA and other forms of tax advantaged Savings Accounts (2)" Transcript
(https://docs.google.com/document/d/e/2PACX-1vQK1Zr0OfiRnCZxJdiHagYBg4f1hlUdjBbtZuftjFoh0-
gQk9x0OdEcPsR3Xl4FC9c_qEmYpT1QGI6w/pub) )
IRA and other forms of tax-advantaged savings accounts (ppt)
(https://byui.instructure.com/courses/294268/files/128080336?wrap=1) (https://byui.instructure.com/courses/294268/files/128080336/download?download_frd=1)
3. Complete the IRA quiz.
An individual who contributes to a Traditional IRA must demonstrate that he or she has at least the same
amount of as the amount contributed to the IRA.
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
2/8
IncorrectQuestion 2
0 / 1 pts
Dollar for dollar up to 3% of income.
A flat 2% no matter how much the employee contributes.
Both of the above.
None of the above.
IncorrectQuestion 3
0 / 1 pts
The individual making the contribution is convicted of a felony.
The individual (or household) making the contribution earns household AGI above a specific limit.
The individual (or household) making the contribution earns household AGI below a specific limit.
Contributions are always tax-deductible. No exceptions.
Question 4
1 / 1 pts
$6,000
$2,750
$6,000 X her marginal tax rate
$0.00 (zero)
Question 5
1 / 1 pts
tax-deferred
tax-free immediately
SIMPLE IRAs allow employers to match what percent of employees contribution?
Contributions to a traditional IRA may not be tax-deductible in the year the contribution was made under
what condition(s)?
Susanne makes $400,000 per year in earned income. She contributes $6,000 to a traditional IRA in
2020. What amount of the $6,000 contribution can she deduct from her taxable income in 2020?
Withdrawals from a Roth IRA are classified as .
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
3/8
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
tax-free after age 59 1/2, assuming the money was in the Roth IRA for a minimum of five years
tax-deferred after age 59 1/2, assuming the money was in the Roth IRA for a minimum of five years
Question 6
1 / 1 pts
tax-free
subject to an early withdrawal penalty
not allowed
subject to a special long-term capital gains tax only
Question 7
1 / 1 pts
tax-free
non-taxable because they are non-qualified
subject to ordinary income tax but are not penalized
subject to an early withdrawal penalty plus ordinary income taxes
Question 8
1 / 1 pts
after-tax dollars
pre-tax dollars
rollover funds only
tax refunds only
Question 9
1 / 1 pts
Roth IRA withdrawals that occur prior to retirement age (non-qualified distributions) are .
Withdrawals from a traditional IRA that occur prior to retirement age (non-qualified withdrawals) are .
A Roth IRA is funded with .
Travis invests $6,000 per year in a Roth IRA. What does the money actually get invested in?
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
4/8
Money market funds.
The Roth Trust Fund. Government sponsored. The Roth Trust fund earns 0.50 percent above the CPI each year.
Returns are guaranteed and government insured.
Fidelity Funds only.
Whatever investments Travis chooses from the list of choices he is offered by the institution that he offered the Roth IRA
account with.
Question 10
1 / 1 pts
Contributions are tax-deductible, if individual (or household) AGI is below a specified limit.
Contributions may not be allowed, if individual (or household) AGI is above a specified limit.
100% of the value of the Roth IRA must be withdrawn in the first five years of the withdrawal period.
Withdrawals after age 59 1/2 (assuming the money was in the account for five years) are taxed at the individual's
ordinary income tax rate.
IncorrectQuestion 11
0 / 1 pts
$6,000
$5,500
$5,000
He is not allowed to contribute.
IncorrectQuestion 12
0 / 1 pts
entire balance of the 401(k) account
employer matching funds only
Individuals contributing to Roth IRAs are subject to which of the following rules?
Gerald makes $1 million per year in earned income. What is the maximum amount he is allowed to
contribute to his Roth IRA in 2020?
Roth 401(k) plans are structured so that withdrawals from the are treated as tax-
free.
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
5/8
employee contributions only
Question 13
1 / 1 pts
publicly traded corporations
government entities
non-profits
self-employed individuals and small businesses
Question 14
1 / 1 pts
$6,000 per year.
$2,000 per year.
No cap. No limit.
$18,000 per year.
IncorrectQuestion 15
0 / 1 pts
$6,000. He is under the limit for contribution "phase-outs."
$2,750. He can only contribute half of the limit because he is over the $68,000 limit on contributions.
$6,500. He can contribute more than normal because of his age. He is taking advantage of the 'catch up' provision.
$0.00 (zero)
IncorrectQuestion 16
0 / 1 pts
$6,000
SEP IRAs are primarily intended for use by .
In 2020, Traditional and Roth IRA contribution limits are generally capped at how much per year?
Alejandro is 55 years old. Alejandro's only source of income is $75,000 in interest income in 2020. He
does not have a job. How much money can Alejandro contribute to his Roth IRA in 2020?
Scarlett makes $50,000 per year in bond interest income. She has no other source of income. She is 57
years old. How much money can she contribute to her traditional IRA in 2020?
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
6/8
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
$6,500 (due to catch-up provision, given her age)
$2,750
$0.00 (zero)
Question 17
1 / 1 pts
Roth IRA
Traditional IRA
SEP IRA
SIMPLE IRA
Question 18
1 / 1 pts
education
retirement
charitable contributions (deferred)
a mission
Question 19
1 / 1 pts
pre-tax dollars
after-tax dollars
rollover funds only
tax-refunds only
Question 20
1 / 1 pts
Which of the following is classified as a tax-free investment account?
A "Coverdell ESA" is intended to help one save for .
Traditional IRAs are funded with .
A 529 plan balance can be transferred to whom?
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
7/8
qualified family members of the beneficiary
anyone
peers that are the same age
anyone who has U.S. citizenship
Quiz Score: 14 out of 20
COPYRIGHT 2024 BRIGHAM YOUNG UNIVERSITY-IDAHO
5/15/24, 6:45 PM
W04 Study & Quiz: IRA: Personal Finance
https://byui.instructure.com/courses/294268/quizzes/4591719
8/8
Related Documents
Related Questions
https://sfdr.owschools.com/owsoo/studentAssignment/index?eh=65534403
SSIGNMENTS
Assignment - 1. Credit Scores and Loans
Attempt 1 of 1
COURSES
SECTION 3 OF 4
QUESTION
1
4
8
You get a personal loan of $5,000 with 12% simple interest too be paid over 30 months. What is your monthly payment?
O $150.00
O $166.67
O $216.67
O $175.00
NEXT QUESTION
O ASK FOR HELP
TURN IT IN
e to search
Pause
T
H
K
B
N
M
Alt
Ct
arrow_forward
A ezto.mheducation.com
Question 46 - Exam 1- Connect
M MHE Reader
* Start Page
Exam 1
360/500 Total points awarded
Submitted
Help
Exit
46
In QuickBooks Online, if the Deposit to: Undeposited Funds account is selected on the Invoice, then funds are recorded directly in
the
0/10
Multiple Choice
points awarded
Scored
Company owner's checking account.
Petty Funds account.
Checking Account.
Undeposited Funds account.
Mc
Graw
Hill
arrow_forward
Class Collaborate-AC-163-44 P x
CengageNOWv2| Online teachin X
+
2.cengagenow.com/ilmn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignments... A
Determine the following measures for 2018.
Round ratio values to one decimal place and dollar amounts to the nearest cent. For number of days' sales in receivables and number of
days' sales in inventory, round intermediate calculations to the nearest whole dollar and final amounts to one decimal place. Assume
there are 365 days in the year.
1. Working capital
Г
2,790,000
2.
Current ratio
4.1
3. Quick ratio
2.5
4.
Accounts receivable turnover
16
5. Days' sales in receivables
22.8
days
6.
Inventory turnover
7. Days sales in inventory
8. Debt ratio
days
%
9. Ratio of liabilities to stockholders' equity
10.
Ratio of fixed assets to long-term liabilities
11. Times interest earned
times
times
12.
Times preferred dividends earned
Check My Work
8
144
0
P
Previous
Email Instructor
Save and Exr
Submit Assignment for Grading
pri se…
arrow_forward
Need help with this question please. Thank you
arrow_forward
Q Search
References
Review
View
Help
Tell me what you want to do
O Editing
I U Dv Av .….
11
A
A B
出<=<三v|
Use the following information to answer questions #1-4
Mrs. Smith has a monthly payment of $230 for health insurance, a $500 deductible, an 80%/20% co-
insurance and co-payments of $15 for prescriptions and $45 for office visits.
1.
What is Mrs. Smith's premium?
a.
$45
b. $230
C.
$500
d. $1,000
2.
What amount will Mrs. Smith have to pay for medical services before the policy begins to pay?
a.
$45
b.
$230
C.
$500
d. $1,000
r for a small nrocedure costing $1,000 what percentage of the me
arrow_forward
Optional.
P Search
vout
References
Mailings
Review
View
Help
Aav Aoミ、E、、三E4T
AaBbCcDc AaBbCcDc AaBbC AaBbCcl AaB
ン、A、三 三三加、、田
I Normal
1 No Spac. Heading 1 Heading 2
Title
Paragraph
Styles
4. Jeff, age 50, is thinking of purchasing a S100,000 permanent life insurance policy to fund a gift to his
local hospital. He was recently treated there after an automobile accident. He does not expect the policy to
be surrendered for a number of years and is concerned that inflation might erode the value of his gift.
Which of the following products would best suit Jeff's needs?
(A) A whole life participating policy with dividends used to reduce the annual premium.
(B) A term to 100 life insurance policy.
(C) A whole life participating policy with a paid-up additions dividend option.
(D) A whole life non-participating policy.
arrow_forward
Please see below. Need this asap please and thank you.
arrow_forward
Subject - account
Please help me.
Thankyou.
arrow_forward
Need your help please. Thank you
arrow_forward
My first question is...are my general journal entries correct? Second question is...What number would be the warrant revenue for year 1?
Please see attachments,
Thank you!
arrow_forward
1
Start with a Blank Excel Workbook
2
Your data will consist of the information provided below
3
Determine the Monthly Payment using the "PMT" formula
4
Create a detailed amortization schedule for the number of months below
5
Amortization schedule must include Interest calculation and a running balance
6
Create a Payment Dates Balance Lookup that uses the VLOOKUP formula to return the Balance for a given date
7
Extra credit (Use a Drop-Down list to select the Look up Date using "Payment Date" from your amortization scheduled
8
Format your document to only print the summary information without the amortization schedule (print on 1 page)
Purchase Amount:
$ 29,000.00
Down Payment Amount
$ 1,000.00
YourName Loan Amount
$ 28,000.00
(Summary Information)
Term (months):
36
Interest Rate (APR):
3.50%
Starting Date
12/7/2021…
arrow_forward
Need help with this questiin please. Thank you
arrow_forward
nt Home
Content
CengageNOWv2| Online teach x
Mail - Niyonzima Focus - Ou
x +
cengagenow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession. *
A
Calculator
A $375,000 bond issue on which there is an unamortized discount of $40,000 is redeemed for $320,000. Journalize the redemption of the bonds.
If an amount box does not require an entry, leave it blank.
Cash
Bonds Payable
Gain on Redemption of Bonds
Cash
arrow_forward
Pls help ASAP
arrow_forward
O Odysseyware
Ô https://sfdr.owschools.com/owsoo/studentAssignment/index?eh=65534403
San Felipe Der RIO CISD- IS
JALYN GARCIA
Odysseyware
LEARN
MESSAGE
HELP
SIGN OUT
Assignment - 1. Credit Scores and Loans
Attempt 1 of 1
ASSIGNMENTS
COURSES
SECTION 3 OF 4
QUESTION 6 OF 8
1
2
4
5
>>
Match the option with the lowest monthly payment to highest monthly payment.
$12,000 loan with 1% simple
1.
lowest payment
interest over 7 years
$7,500 loan with 4% simple interest
2. second highest payment
over 5 years
$8,500 loan with 2% simple
3. third highest payment
interest over 6 years
$10,000 loan with 3% simple
4. fourth highest payment
interest over 4 years
9:19 PM
后 ENG
2/4/2021
P Type here to search
R
arrow_forward
249.acellus.com/StudentFunctions/Interface/acellus_engine.html?ClasslID=362492186
le
* Menu
Read180/Sys44
© Schoology
Bb SKUSD
GW G-W Online Textbo... O NHA
https://my.hrw.com...
Readine
Installment Loan
How much of the first
payment for the
installment loan
18% shown in the table will
Principal
$2000.00
Term Length
2 years
Interest Rate
go towards principal?
Monthly Payment
$100.00
B. $70.00
A. $88.00
D. $30.00
C. $111.00
1:59 AM
10/18/2021
AD) ENG
arrow_forward
Can you please help me solve this
arrow_forward
Calculate the table factor, the finance charge, and the monthly payment (in
$) for the loan by using the APR table, Table 13-1. (Round your answers to
the nearest cent.)
Monthly
Payment
Amount
Number of
Table
Finance
APR
Financed
Payments
Factor
Charge
$9,300
36
13%
$
Need Help?
Read It
Viewing Saved Work Revert to Last Response
Submit Answer
arrow_forward
Milestone #1 – Research Project Overview (Week Two)
Introduction: Provide a brief overview of the research healthcare. Describe the topic you are focusing on and establish the rationale behind your choice. Use the model for introduction on page 111 in Creswell & Creswell.
Purpose: Describe the main topics that you will examine in the context of the survey. You do not need to discuss the specific survey questions here. Rather, focus on the broader topics and themes that you will address in the questionnaire. Creswell & Creswell (2023) discuss this in Chapter 6.
arrow_forward
ccounting | Spring 2023
uiz
Course Home - kar X
K
Chapter 9 Quiz
OA. $18,200
OB. $18,800
OC. $17,500
O D. $20,300
mylab.pearson.com
Question 5 of 10
X G At year-end, Snow
0
4
kara harper 04/09/23 10:36 AM
This quiz: 10 point(s)
possible
This question: 1
point(s) possible
?
Submit quiz
Buddy Company uses the allowance method to account for uncollectible receivables. At the beginning of the year,
Allowance for Bad Debts had a credit balance of $800. During the year Buddy wrote off uncollectible receivables of
$2,100. Buddy recorded Bad Debts Expense of $2,800. Buddy's year-end balance in Allowance for Bad Debts is
$1,500. Buddy's ending balance of Accounts Receivable is $20,300. Compute the net realizable value of Accounts
Receivable at year-end.
arrow_forward
A moodle.jamessprunt.edu/mod/quiz/attempt.php?attempt3D473287&cmid%3D605671&page%3D10
CC
JSCC Homepage - Tech Support Student Toolbox JSCC Bookstore English (United States) (en_us) -
For each account below, indicate the normal balance of the account.
Notes Payable (due in 5 years)
=21
Choose.
tion
Advertising Expense
Choose.,
Cash
Choose.
J. Smith, Capital
Choose.
Accumulated Depreciation
Choose.
J. Smith, Drawing
Choose.
Rent Revenue
Choose.
Land
Choose.
Sales
Choose.
Mortgage Payable
Choose.
Interest Expense
Choose.
Merchandise Inventory
Choose.
Depreciation Expense - Office Building Choose.
Accounts Payable
Choose.
Depreciation Expense - Store
Choose.
Customer Refunds Payable
Choose.
Freight Out
Choose.
Accounts Receivable
Choose.
Office Supplies Expense
Choose.
Unearned Rent
Choose. :
Prepaid Insurance
Choose..
Type here to search
hp
立
arrow_forward
Safari File Edit View History Bookmarks Window Help
Inbox (3,222) - tonygonzalez0100@g...
Bb Welcome, Tony - Blackboard Learn
learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com
Screenshot
2. Suppose Grandma wants to accumulate $100,000 for her grandchild's college education in 18
years. How much must she deposit today into an account with an APR of 4%, compounded
semiannually in order to have $100,000 in 18 years? Assume no additional deposits are made.
O
Bb NCBM 0222/MATD 0485 Unit 4 Conte...
DEC
7
Bb https://learn-us-east-1-prod-fleet02-x...
3. You want to save enough to have $40,000 for a down payment on a house in 6 years. How much
should you deposit today into an account with an APR of 4% compounded weekly in order to
have the down payment in 6 years?
tvi
PV:
=
PMT=
FV =
APR =
Periods =
Compounding:
PV: =
PMT=
FV =
APR =
Periods =
Compounding:
A
32
Wed Dec 7 12:03 AM
b Search results for 'Suppose Grandma...
t
PM
PM
. PM
t
t
PM
PM
t
PM
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!
arrow_forward
hi tutor.Could you write down the answer?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- https://sfdr.owschools.com/owsoo/studentAssignment/index?eh=65534403 SSIGNMENTS Assignment - 1. Credit Scores and Loans Attempt 1 of 1 COURSES SECTION 3 OF 4 QUESTION 1 4 8 You get a personal loan of $5,000 with 12% simple interest too be paid over 30 months. What is your monthly payment? O $150.00 O $166.67 O $216.67 O $175.00 NEXT QUESTION O ASK FOR HELP TURN IT IN e to search Pause T H K B N M Alt Ctarrow_forwardA ezto.mheducation.com Question 46 - Exam 1- Connect M MHE Reader * Start Page Exam 1 360/500 Total points awarded Submitted Help Exit 46 In QuickBooks Online, if the Deposit to: Undeposited Funds account is selected on the Invoice, then funds are recorded directly in the 0/10 Multiple Choice points awarded Scored Company owner's checking account. Petty Funds account. Checking Account. Undeposited Funds account. Mc Graw Hillarrow_forwardClass Collaborate-AC-163-44 P x CengageNOWv2| Online teachin X + 2.cengagenow.com/ilmn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignments... A Determine the following measures for 2018. Round ratio values to one decimal place and dollar amounts to the nearest cent. For number of days' sales in receivables and number of days' sales in inventory, round intermediate calculations to the nearest whole dollar and final amounts to one decimal place. Assume there are 365 days in the year. 1. Working capital Г 2,790,000 2. Current ratio 4.1 3. Quick ratio 2.5 4. Accounts receivable turnover 16 5. Days' sales in receivables 22.8 days 6. Inventory turnover 7. Days sales in inventory 8. Debt ratio days % 9. Ratio of liabilities to stockholders' equity 10. Ratio of fixed assets to long-term liabilities 11. Times interest earned times times 12. Times preferred dividends earned Check My Work 8 144 0 P Previous Email Instructor Save and Exr Submit Assignment for Grading pri se…arrow_forward
- Need help with this question please. Thank youarrow_forwardQ Search References Review View Help Tell me what you want to do O Editing I U Dv Av .…. 11 A A B 出<=<三v| Use the following information to answer questions #1-4 Mrs. Smith has a monthly payment of $230 for health insurance, a $500 deductible, an 80%/20% co- insurance and co-payments of $15 for prescriptions and $45 for office visits. 1. What is Mrs. Smith's premium? a. $45 b. $230 C. $500 d. $1,000 2. What amount will Mrs. Smith have to pay for medical services before the policy begins to pay? a. $45 b. $230 C. $500 d. $1,000 r for a small nrocedure costing $1,000 what percentage of the mearrow_forwardOptional. P Search vout References Mailings Review View Help Aav Aoミ、E、、三E4T AaBbCcDc AaBbCcDc AaBbC AaBbCcl AaB ン、A、三 三三加、、田 I Normal 1 No Spac. Heading 1 Heading 2 Title Paragraph Styles 4. Jeff, age 50, is thinking of purchasing a S100,000 permanent life insurance policy to fund a gift to his local hospital. He was recently treated there after an automobile accident. He does not expect the policy to be surrendered for a number of years and is concerned that inflation might erode the value of his gift. Which of the following products would best suit Jeff's needs? (A) A whole life participating policy with dividends used to reduce the annual premium. (B) A term to 100 life insurance policy. (C) A whole life participating policy with a paid-up additions dividend option. (D) A whole life non-participating policy.arrow_forward
- My first question is...are my general journal entries correct? Second question is...What number would be the warrant revenue for year 1? Please see attachments, Thank you!arrow_forward1 Start with a Blank Excel Workbook 2 Your data will consist of the information provided below 3 Determine the Monthly Payment using the "PMT" formula 4 Create a detailed amortization schedule for the number of months below 5 Amortization schedule must include Interest calculation and a running balance 6 Create a Payment Dates Balance Lookup that uses the VLOOKUP formula to return the Balance for a given date 7 Extra credit (Use a Drop-Down list to select the Look up Date using "Payment Date" from your amortization scheduled 8 Format your document to only print the summary information without the amortization schedule (print on 1 page) Purchase Amount: $ 29,000.00 Down Payment Amount $ 1,000.00 YourName Loan Amount $ 28,000.00 (Summary Information) Term (months): 36 Interest Rate (APR): 3.50% Starting Date 12/7/2021…arrow_forwardNeed help with this questiin please. Thank youarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- PFIN (with PFIN Online, 1 term (6 months) Printed...FinanceISBN:9781337117005Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning