Copy of 2301_LG1-2 Project
pdf
keyboard_arrow_up
School
University of California, Riverside *
*We aren’t endorsed by this school
Course
1301
Subject
Finance
Date
Apr 3, 2024
Type
Pages
3
Uploaded by MagistrateExplorationKouprey12
PFI 2301: Personal Financial Literacy
Information Sheet
Project Overview: Throughout the semester, you will be working on an application based scenario on how to apply the course learning goals. All projects will be submitted through Excel. The "Info Sheet" (where you're now) will be the landing page for all of the information to complete each Learning Goal Project. Make sure to keep up with the schedule for the due dates and review the rubrics to make sure you know how each Project will be graded. Let's get started! Unit 1: BASICS - The Tools and the Rules of Personal Finance
LG1-Understand financial literacy and how it relates to the financial planning process over the life cycle.
LG2-Understand opportunity cost and the time value of money calculations in relation to financial goals.
FINANCIAL GOALS (Q8-Q12) -
Based on the scenario, type the TVM inputs in the table to figure out what you are solving for (no additional compounding steps here). Short-Term
Goal 1:
Opened an account with $1500, with the hope to have a total of $2500 saved in an emergency fund within one year (no additional payments). RATE
NPER
PMT
PV
FV
Goal 2:
A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card by the end of the year. (future is a $0 balance)
RATE
NPER
PMT
PV
FV
Intermediate-Term
Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future is a $0 balance)
RATE
NPER
PMT
PV
FV
Goal 4: Save $15000 in an account with 15% interest for a down payment on a home in 6 years. (no additional payments)
RATE
NPER
PMT
PV
FV
Long-Term
Goal 5: Open a Roth IRA at 5% for 20 years and contribute $1500 on a semi-annual basis. RATE
NPER
PMT
PV
FV
PFI 2301: Personal Financial Literacy
LG1 & 2 Project
LG1-Q1
Focus on YOU! 1) De fine financial literacy and 2) how does financial literacy relate to the life cycle stage you're currently in. (type responses, no calculations needed)
Financial Literacy is the cognitive understanding of financial components and skills such as budgeting, investing, borrowing, taxation, and personal financial management. For me financial literacy relates to this stage of my life is budgeting for grocerys, rent and my sorority dues. LG2-Q2
Focus on YOU! Create one life and one financial goal using the SMART goal process. State each goal below, then make the goal SMART! (type responses, no calculations needed)
Life Goal
Owning a dance studio and becoming a dance teacher
S
I want to be able to teach young dancers all the way to when they graduate highschool M
I have been able to measure this by working over the summer with dancers and dance teams and how often i have been requested to work with dancers
A
I have been able to work with highschool dance teams and soloist with choreographing and cleaning dances
R
I have been dancing for 13 years and i have been teaching for 4 years now
T
I want to start working at a dance studio after graduation and own my own studio at 25
Financial Goal
save 2,000 for an emergancy fund
S
Have 2,000 dollars in savings for after i graduate college
M
start saving 20 dollars a month A
create a monthly budgeting plan to fit the 20 dollar savings into it
R
Have this fund to be able to have some money after i graduate incase something happens T
Have at least 1,000 by the end of the next spring semester
Application Time! Facts about Jessica - Complete the following TVM questions (Q3-Q7). Here you will be provided with additional guidance, use the dropdown boxes for 'a-c' to help calculate the TVM problem. Hint: A negative sign can also result in what you're solving for
Hint: 1= Annually, 2= Semi-Annually, 4= Qtr., 12= Monthly
Note: RATE = % / Compounding #
Note: NPER * Compounding #
LG2-Q3
Jessica was thinking of making an investment for $6000. She expects it to increase in value at a rate of 3.5% compounded annually for the next five years. How much will the investment be worth at the end of the fifth year?
a) Solving For?
(select from dropdown)
b) Which input is negative? (type TVM input(s) below)
c) Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
From the scenario type out the TVM inputs in the cells.
FV
PV
1
3.50% 5.000
105000
-6000
7126
#N/A
LG2-Q4
In college, Jessica borrowed $3200 from her father to study abroad. She paid back $4000 to her father at the end of 4 years. What was the average annual compound rate of interest on the loan from her father?
a) Solving For?
(select from dropdown)
b) Which input is negative? (type TVM input(s) below)
c) Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
From the scenario type out the TVM inputs in the cells.
RATE
FV
1
5.740
4
0
3,200.o
4000
#N/A
LG2-Q5
Jessica would like to open a savings account. How many years will it take $2500 to grow to $4500 with an interest rate of 3.0%?
a) Solving For?
(select from dropdown)
b) Which input is negative? (type TVM input(s) below)
c) Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
From the scenario type out the TVM inputs in the cells.
NPER
PV
1
3.000
19.89
0
-2500
4500
#N/A
LG2-Q6
Jessica's grandparents opened a savings account when she was born and could access the funds when she turned 18. The account is currently at $16000 and grew at a rate of 2%. What was the initial amount invested?
a) Solving For?
(select from dropdown)
b) Which input is negative? (type TVM input(s) below)
c) Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
From the scenario type out the TVM inputs in the cells.
PV
FV
1
2.000
18
0
11202.55
16000
#N/A
LG2-Q7
Jessica would like to go on a cruise in one year. The total trip costs $1500. She is thinking of placing the funds in an account that earns a little interest - she found an account with .5% interest. To reach this goal, how much would Jessica need to contribute to this account monthly?
a) Solving For?
(select from dropdown)
b) Which input is negative? (type TVM input(s) below)
c) Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
From the scenario type out the TVM inputs in the cells.
PMT
FV
1
3.5000
5
0.00
6000
7126
#N/A
Application Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2) Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed, compound. 4) In the "ANSWER" cell show us your TVM calculation.
Note: RATE = % / Compounding #
Note: NPER * Compounding #
LG2-Q8
Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an emergency fund within one year (no additional payments). Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
ANSWER What would the quarterly interest rate be needed to reach this goal?°
1
14
4
0
1000
2000
42.67%
#N/A
LG2-Q9
Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card by the end of the year. (future is a $0 balance)
Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
ANSWER What would be the monthly payment to reach this goal?
1
15.0000
12
12
-2000
0
180.52
#N/A
LG2-Q10
Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future is a $0 balance)
Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
ANSWER How many months will it take to complete this goal?
1
6.5000
7
12
425
-18000
48.24
#N/A
LG2-Q11
Goal 4: Save $15000 in an account with 15% for a down payment on a home in 6 years. (no additional payments)
Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
ANSWER How much must be deposited today in the account to reach this goal?
1
15.00
6
0
-15000
0
6484.91
#N/A
LG2-Q12
Goal 5: Open a Roth IRA at 5% for 20 years and contribute $1500 on a semi-annual basis. Compounding Number (select from dropdown)
RATE NPER
PMT
PV
FV
ANSWER What is the potential balance of this account in 20 years?
1
5.0000
2
20
-1500
0
101103.83
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 Documents
Related Questions
You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process:
Costs/Benefits
College Course
Community Course
Cost
$4,300
$1,190
Distance to course
0.20 miles (walking distance)
18 miles (driving distance)
Timing of course
Weekday
Weekend
Number of meetings
16
8
Qualitative considerations
Convenience, quality of instruction
Flexibility, brief duration
Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose?
Multiple Choice
College course
Community course
Both alternatives
Neither alternative
arrow_forward
Construct the amortization schedule for a $8000 debt that is to be amortized in 6 equal quarterly payments at 2% interest per quarter on the unpaid balance. How much interest must be paid?
After you are ready, choose the "Finish attempt" option, and then "Submit all and finish". After this, take a picture or scan your solution and upload it into the e-learning system. You should upload the solution in jpg or pdf format. Please, write legibly. If I can not read your solution, I can not give points either.
arrow_forward
Learning
SE MINDTAP
evo/index.html?deploymentid=60338517901669990751687760&elSBN=9780357517642&nbld=3626933&snap... ☆
lomework
6300.
1
mancial Lailuialvi vi a spicoubnicel.
Hide Feedback
Correct
X
f6
Quantitative Problem 1: You plan to deposit $2,200 per year for 6 years into a money market account with an annual return of 2%. You plan
to make your first deposit one year from today.
a. What amount will be in your account at the end of 6 years? Do not round intermediate calculations. Round your answer to the nearest cent.
4
b. Assume that your deposits will begin today. What amount will be in your account after 6 years? Do not round intermediate calculations.
Round your answer to the nearest cent.
6
Hide Feedback
Incorrect
F
Check My Work Feedback
Review the FVAN definition and its equation.
Q Search
Understand the difference between an ordinary annuity and an annuity due.
Be careful about the order of mathematical operations if using the equation.
If using a financial calculator, be…
arrow_forward
Hi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?
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
myOpenMath
Course Messages Forums Calendar | Gradebook
Home > Math 173-4 Spring 2024> Assessment
Quiz 2 (Sec. 1.5-1.7)
54 points possible 5/12 answered
Question 6
The graph of the function
y = f(x - 39)
can be obtained from the graph of
y = f(x)
by one of the following actions:
> Next Question
Home | My
Oshifting the graph of f(x) to the right 39 units
shifting the graph of f(x) to the left 39 units
shifting the graph of f(x) upwards 39 units
shifting the graph of f(x) downwards 39 units
arrow_forward
MindTap - Cengage Learning
2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false
ork
items
week 6: Homework
eBook
Salary
State income taxes
Exercise 12-22 (Algorithmic) (LO. 2, 3, 5)
Yanni, who is single, provides you with the following information for 2021:
CengageNOWv2 | Online teachin X
Print Item
Mortgage interest expense on principal
residence
Charitable contributions
Interest income
a. Yanni's taxable income:
b. Yanni's AMT base:
Check My Work
Click here to access the exemption table. If required, round your answers to the nearest dollar.
Compute the following:
c. Yanni's tentative minimum tax:
$117,400
11,740
10,566
2,348
1,761
94,507
32,647
X +
8,488
arrow_forward
Submit a paragraph stating that you have completed the setup for QuickBooks Online, which includes the registration for Quickbooks Online for students, downloading and setting up files from LinkedIn Learning course, QuickBooks Online Essential Training, and verifying access to the QuickBooks Online ebook, Mastering Quickbooks 2021: The Ultimate Guide to Bookkeeping and QuickBooks Online, 2nd Edition.
arrow_forward
Screenshot of question is attached.
thanks in advance
arrow_forward
Make a textual information from this Enrollment by Key Stage
arrow_forward
Reference:
https://pdfroom.com/books/personal-finance-10th-edition/JzydD6rQ214
page.33
arrow_forward
Please see below. I need help with this excel sheet. Note, please be sure to use cell referencing and the appropriate formulas for each part.
arrow_forward
Please see below. Be sure to include the appropriate mathematical formulas and cell referencing for this question. These two items are required!!!!
arrow_forward
PowerSchool Leaming : Portal : D
A ANet Online
4DC
a login.achievementnetwork.org/tutti/learn/assignments/viewAssignment.svc?ciid3FE954372A54D406885C1144055..
A1 Math Algebra II 20-21 Form MT Online
Screen Settings
9 of 9
* Full Screen
I Sa
Main Street Bank has savings accounts that earn 0.8% interest per month. All deposits, interest payments, and account closures are processed on the first day of a month
Part A
Assume a customer deposits the same amount of money, x, in dollars, each month. Write an expression that can be used to determine how much money would be in a savings account from Main
Street Bank after n months.
Respond in the space provided.
Part B
Luciana and Valerie are both opening savings accounts at Main Street Bank and will close their savings accounts at the end of their savings strategy Luciana's savings strategy is to deposit $200
each month for 24 months. Valerie's savings strategy is to deposit $400 each month for 12 months.
Whose savings strategy will result in…
arrow_forward
. Download Target’s 2021 annual report. Do this in one of two ways:
Go to the Target.com website: Annual Reports and Archive (target.com). Make sure you use the 2021 report.
Or use the Mergent Online library database: https://guides.rasmussen.edu/mergent.
2. Using Target’s annual report, record your findings in a written report.
Use complete sentences in a report format.
Double-space your report.
The report should be 5 paragraphs. Include a brief introduction, report the requested information from the three paragraphs below, and write a summary paragraph.
Include in-text citations and an APA format reference page. There should be at least one reference given for the 2021 annual report. FAQ citing an annual report from Mergent Online FAQ citing an annual report from a website.
Paragraph one: The statements start on about page 38. Use the 2021 numbers. Using a table, record the total revenue, operating income, and net earnings for 2021. Using sentences, explain what these numbers…
arrow_forward
do assignments using excel and manually if possibly
A student plans to open a business with the courage to borrow $1740,11 and will return the same amount every year for 5 years. If the loan interest from (Small Business Credit) is 6%/year. How much is the student's installment/year?
arrow_forward
Hey I was wondering if I can get help with this thank you
arrow_forward
Please see below. Need help with this asap please and thank you.
arrow_forward
os.schoolsplp.com/enrollments/156569804/items/YUI32/work?prev3LNSDS
O Western Brown Loc.
Desmos | Graphing. A ALEKS- Gracie Glov.
M My Classes | McGra. A Classes
Next Activity >
els B: Lesson 1 - Salary
Target due: 1/14/21 58.33%
$344.75
$700
2) Choose the best answer.
Caleb has a job that pays $11.15 per hour for a 40-hour work week. He is paid time
and a half for every hour over 40 that he works in a week. What will his gross pay be
for a week in which he works 46 hours?
NTT
$546.35
$446
$512.90
$256.45
$769.35
O O O
O O
arrow_forward
Select a topic (within the last 12 months) on Technology from the IMA Count Me in Podcast SeriesLinks to an external site.. Share a brief overview of your selection, key points learned, and why you selected it. Include a link to the Podcast.
arrow_forward
Each Section should be completed in a separate spreadsheet tab and all calculations should be performed using Excel formulas:
You graduated from college and landed a new job that will start in a couple of weeks. You need to purchase a car to commute to and from your new place of employment. You have decided to buy a car that costs $40,000, and will make a $5,000 down payment, resulting in the need to take out a $35,000 loan with a 5% annual interest rate that you will pay off in equal monthly installments over the next 5 years (60 months). Calculate and provide the following information:
a) Calculate the monthly payment on the car loan.
b) Prepare an amortization table for the car loan that provides separate columns for the following for each month of the car loan: Beginning loan balance; total payment amount, amount of monthly payment allocated to interest; amount of monthly payment allocated to the principal balance; and ending loan balance. (Your amortization table is likely…
arrow_forward
Digital Learning
* CengageNOwv2 | Online teachir
* Cengage Learning
+
Assignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
A eBook
Show Me How
Percent of Sales Method
At the end of the current year, Accounts Receivable has a balance of $555,000; Allowance for Doubtful Accounts has a credit balance of $5,000; and sales for
the year total $2,500,000. Bad debt expense is estimated at 1/4 of 1% of sales.
a. Determine the amount of the adjusting entry for uncollectible accounts.
b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense.
Accounts Receivable
24
Allowance for Doubtful Accounts
Bad Debt Expense
%24
c. Determine the net realizable value of accounts receivable.
Feedback
Check My Work
a. Remember that since accounts receivable are created by credit sales, uncollectible accounts çan be estimated as a percent of credit sales. If the
portion of credit sales to sales id relatively constant, the…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process: Costs/Benefits College Course Community Course Cost $4,300 $1,190 Distance to course 0.20 miles (walking distance) 18 miles (driving distance) Timing of course Weekday Weekend Number of meetings 16 8 Qualitative considerations Convenience, quality of instruction Flexibility, brief duration Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose? Multiple Choice College course Community course Both alternatives Neither alternativearrow_forwardConstruct the amortization schedule for a $8000 debt that is to be amortized in 6 equal quarterly payments at 2% interest per quarter on the unpaid balance. How much interest must be paid? After you are ready, choose the "Finish attempt" option, and then "Submit all and finish". After this, take a picture or scan your solution and upload it into the e-learning system. You should upload the solution in jpg or pdf format. Please, write legibly. If I can not read your solution, I can not give points either.arrow_forwardLearning SE MINDTAP evo/index.html?deploymentid=60338517901669990751687760&elSBN=9780357517642&nbld=3626933&snap... ☆ lomework 6300. 1 mancial Lailuialvi vi a spicoubnicel. Hide Feedback Correct X f6 Quantitative Problem 1: You plan to deposit $2,200 per year for 6 years into a money market account with an annual return of 2%. You plan to make your first deposit one year from today. a. What amount will be in your account at the end of 6 years? Do not round intermediate calculations. Round your answer to the nearest cent. 4 b. Assume that your deposits will begin today. What amount will be in your account after 6 years? Do not round intermediate calculations. Round your answer to the nearest cent. 6 Hide Feedback Incorrect F Check My Work Feedback Review the FVAN definition and its equation. Q Search Understand the difference between an ordinary annuity and an annuity due. Be careful about the order of mathematical operations if using the equation. If using a financial calculator, be…arrow_forward
- Hi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?arrow_forwardhelp 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 workingarrow_forwardmyOpenMath Course Messages Forums Calendar | Gradebook Home > Math 173-4 Spring 2024> Assessment Quiz 2 (Sec. 1.5-1.7) 54 points possible 5/12 answered Question 6 The graph of the function y = f(x - 39) can be obtained from the graph of y = f(x) by one of the following actions: > Next Question Home | My Oshifting the graph of f(x) to the right 39 units shifting the graph of f(x) to the left 39 units shifting the graph of f(x) upwards 39 units shifting the graph of f(x) downwards 39 unitsarrow_forward
- MindTap - Cengage Learning 2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false ork items week 6: Homework eBook Salary State income taxes Exercise 12-22 (Algorithmic) (LO. 2, 3, 5) Yanni, who is single, provides you with the following information for 2021: CengageNOWv2 | Online teachin X Print Item Mortgage interest expense on principal residence Charitable contributions Interest income a. Yanni's taxable income: b. Yanni's AMT base: Check My Work Click here to access the exemption table. If required, round your answers to the nearest dollar. Compute the following: c. Yanni's tentative minimum tax: $117,400 11,740 10,566 2,348 1,761 94,507 32,647 X + 8,488arrow_forwardSubmit a paragraph stating that you have completed the setup for QuickBooks Online, which includes the registration for Quickbooks Online for students, downloading and setting up files from LinkedIn Learning course, QuickBooks Online Essential Training, and verifying access to the QuickBooks Online ebook, Mastering Quickbooks 2021: The Ultimate Guide to Bookkeeping and QuickBooks Online, 2nd Edition.arrow_forwardScreenshot of question is attached. thanks in advancearrow_forward
- Make a textual information from this Enrollment by Key Stagearrow_forwardReference: https://pdfroom.com/books/personal-finance-10th-edition/JzydD6rQ214 page.33arrow_forwardPlease see below. I need help with this excel sheet. Note, please be sure to use cell referencing and the appropriate formulas for each part.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning