worked lab solutions
.pdf
keyboard_arrow_up
School
McMaster University *
*We aren’t endorsed by this school
Course
401
Subject
Finance
Date
Feb 20, 2024
Type
Pages
18
Uploaded by DoctorPony4131
Lab 1 Julia brings home $1,900 per month after taxes. Her rent is $489 per month, her utilities are $96 per month, and her car payment is $219 per month. Julia is currently paying $135 per month to her orthodontist for maintenance of her braces. If Julia's groceries cost $84 per week and she estimates her other expenses to be $224 per month, how much will she have left each month to put toward savings to reach her financial goals? Julia brings home $2,600 per month after taxes. Her rent is $792 per month, her utilities are $191 per month, and her car payment is $389 per month. Julia is currently paying $184 per month to her orthodontist for maintenance of her braces. Julia is considering trading in her car for a new one. Her new car payment will be $461 per month, and her insurance cost will increase by $39 per month. Julia determines that her other car-related expenses (gas, oil) will stay about the same. What is the opportunity cost if Julia purchases the new car? Mia has $3,310 in her chequing account, a furniture loan for $612, and an outstanding credit card balance of $118. Mia's monthly disposable income is $1,655, and she has monthly expenses of $1,363. What is Mia's net worth? 1900
489
219
135
84
4
224
497
461
389
72
72
39
111
opportunity
cost
Networth
Assets
Liabilities
Liabilities
612
118
730
Networth
3310
730
2580
At the beginning of the year, Arianne had a net worth of $5,300. During the year, she set aside $80 per month from her paycheque for savings and borrowed $500 from her cousin that she must pay back in January of next year. What was her net worth at the end of the year? Anna has just received a gift of $390 for her graduation, increasing her net worth by $390. If she uses the money to purchase a smartwatch, how will her net worth be affected? If she invests the $390 at 5 percent compounded annually, what will it be worth in one year? Jason's car was just stolen, and the police informed him that they will probably be unable to recover it. His insurance will not cover the theft. Jason has a net worth of $4,000, all of which is easily convertible to cash. Jason requires a car for his job and his daily life. Based on Jason's net cash flow, he cannot afford more than $350 in car payments. What options does he have? How will these options affect his net worth and net cash flow? What options does Jason have and how will these options affect his net worth and net cash flow? Net
worth
5300
80 12
500
5760
smartwatch
no
change
in net
worthas
exchanging
oneasset
for
another
invests
390 390 0.05
409.50
He
can
convert
his
net
worth
to
cash
andavoid
any
effect
on
his
net
cash
flow
He
could
also
borrow
the
needed
amount
which
will
reduce
his
netcash
flow
and
net
worth
Lab 2 How much interest will you pay on a loan of $19,400 if you are paying the loan off in 13 months? Your loan rate is 4.001 percent.
Earl wants to know how much he will have available to spend on his trip to Belize in three years. If he deposits $4,300 today at an interest rate of 9 percent interest compounded quarterly, how much will Earl have available to spend on his trip to Belize in three years? Cheryl wants to have $3,900 in spending money to take on a trip to Niagara Falls in three years. How much must she deposit now in a savings account that pays 4 percent compounded monthly to have the money she needs in three years? 19400 0.04001
x
I
840.88
in
interest
in
excel
FV
n
per
3
4
quarterly
Rate
0.09
4
PV 4300
FV
5616.01
in
excel PV
rate
0.04
12
monthly
n
per
3
X
12
FV
3900
PV
3459.68
Michelle is attending college and has a part-time job. Once she finishes college, Michelle would like to relocate to a metropolitan area. She wants to build her savings so that she will have a "nest egg" to start her off. Michelle works out her budget and decides that she can afford to set aside $130 per month for savings. Her bank will pay her 4 percent interest compounded monthly on her savings account. What will Michelle's balance be in five years? Farah will receive $1,350 each year for 15 years from an ordinary annuity that she recently purchased. If she earns interest at a rate of 7.9 percent compounded annually, what is the present value of the amount that she will receive? Jeron invests $70 per month, at the beginning of each month, at 4 percent interest compounded weekly. How long, in years, will it take him to accumulate $5,000? The effective interest rate on your credit card is 31 percent. What is the equivalent nominal interest rate if interest compounds daily? (EFF) in
excel
FV
rate
0.04 12
h
per
5
12
PMT 130
FU
8618.87
in
excel
PV
rate
0.079
n
per
15
PMT
1350
PV
11626.19
Withcalculator
I
4
Fk
gooo
Ve
Gr
n
64.17
PMI
70
64.17 12
months
5.3
years
Ply
12
Cry
52
TVM FSC
CNUT
II
36,5
daily
APR
nominal
interest
rate
Press
APR
APR
27.013
Lab 3 Angela earns $3,000 per month before taxes in her full-time job and $1,000 per month before taxes in her part-time job. About $850 per month is needed to pay taxes and other payroll deductions. What is Angela's monthly disposable income?
Angela inspects her chequebook and credit card bills and determines that she has the following monthly expenses: Rent $520 Cable TV 25 Electricity 100 Water 30 Telephone 55 Groceries 510 Car expenses 370 Disability insurance 110 Critical Illness insurance 120 Clothing and personal items 170 Recreation 340 What is Angela's net cash flow if Angela's disposable income is $3,140? 3000
1000
850
3150
in
disposable
income
sum
expense
total
2350
net
cash
flow
3140
2350
790
If Angela is saving $643 per month and her disposable income is $2,900, Angela's savings ratio (that is, savings as a percentage of disposable income) is A recent car accident has Ali and Nazra Khan concerned about their ability to meet financial emergencies. Help them calculate their current ratio given the following assets and liabilities. $2,400
$3,100
$8,100
$510
$1,000
Auto loan (1-year remaining)
$3,100
Paul is a student. All of Paul's disposable income is used to pay for his post-secondary education expenses. While he has no liabilities (he is on a scholarship), he does have a credit card that he typically uses for emergencies. He and a friend went on a shopping spree in Toronto costing $1,300, which Paul charged to his credit card. Paul has $54.629901924 in his wallet, but his bank accounts are empty. Paul's current ratio is 643
2900
22
17
Current
ratio
Liquid
assets
current
liabilities
one
year
Liquid
assets
2400
3100
8100
13600
current
liabilities
510
1000
3100
4610
Currentratio
13600
4610
2.95
Current
ratio
54.629901924
0.042
1300
for
every
dollar
in
current
liabilities
he has
0.04 in
liquidassets
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
3
arrow_forward
Accounting
Henry makes $13.67/hr. at his job and he
normally works 43 hours per week. His expenses
each month are $940/month for rent,
$529.26/month for utilities, and $410/month for
food and clothing. He wants to buy a car, but
the payments are $382.74/month. If Henry pays
15% of his income to taxes and insurance, can
he afford this new car? Give your answer as the
amount of money left after the car payment is
added or give a negative number of the money
he earns is not enough. Assume a month is 4
weeks.
Round to the nearest cent.
arrow_forward
3. What house value can Betty afford? Betty's annual income is $90,000 and
she has monthly credit payments of $500. She is looking for a house
financed by 30 year 6% mortgage with 20% down payment. Property tax
and insurance on the home is expected to be $300 per month. Calculate the
value of the house she can afford.
arrow_forward
Financial accounting
arrow_forward
K
Estimating the Opportunity Cost. Julia brings home $1,790 per month after taxes Julia's rent is $366 per month, her utilities are 597 per month, and her car payment is
$260 per month. Julia is currently paying $231 per month to her orthodontist for her braces Julia's groceries cost $30 per week and she estimates her other expenses to be
$167 per month As a result, she has $517 left each month to put toward savings to reach her financial goals Julia is considering trading in her car for a new one Her new
car payment will be $348 per month, and her insurance cost will increase by $57 per month Julia determines that her other car-related expenses (gas, oll) will stay about
the same. What is the opportunity cost if Julia purchases the new car?
The opportunity cost if Julia purchases the new car is 5
(Round to the nearest dollar)
arrow_forward
Starting on the day Kelly was born, her mother has invested $50 at the beginning of every month in a savings account that earns 2.20% compounded monthly.
a. How much did Kelly have in this account on her 22nd birthday? Assume that there was no deposit on that day.
b. What was her mother's total investment?
c. How much interest did the investment earn?
How much should Diana's dad invest into a savings account today, to be able to pay for Diana's rent for the next five years if rent is $950 payable at the beginning of each month? The savings account earns 3.75% compounded monthly.
arrow_forward
Timothy Mother Ms. Parker find out her Monthly Rent is $496.00 every month but she owes $13,842.00 but she gonna got $6,000 save up in the bank how much more she post to take out to add up to that amount?
arrow_forward
6) Susan is looking to purchase her first home five years from today. The house costs $1,550,000. She
will have to make a down payment of 10% of this amount and plans to take a loan from the bank for
the difference. Bank charges are approximately 15% of the loan amount. She plans to start saving
from today to cover both the down payment and the bank charges.
a. How much will she need to save to cover both the down payment and bank charges?
b. If she currently has $195,000 in her account and will make no further deposits over the next five
years, what rate of interest must she earn on this account in order to achieve the savings target
calculated in part (a) above?
arrow_forward
How much should Bianca's dad invest into a savings account today, to be able to pay for Bianca's rent for the next two years if rent is $850 payable at the beginning of each month? The savings account earns 2.50% compounded monthly
Courtney set up a savings fund for his son's education so that he would be able to withdraw $1,600 at the beginning of every month for the next 4 years. The fund earns 4.89% compounded quarterly.
a. What amount should he deposit today to allow for the $1,600 periodic withdrawals?
$57,837.41
$69,654.42
$69,937.11
$58,544.47
b. How much interest would he earn in this investment?
$69,937.11
$6,862.89
$76,800.00
$7,145.58
arrow_forward
11. Can I afford this home? - Part 1
Can Valerie and Shen afford this home using the monthly income loan criterion?
Next week, your friends Valerie and Shen want to apply to the Tenth National Bank for a mortgage loan. They are considering the purchase of a home
that is expected to cost $155,000. Given your knowledge of personal finance, they've asked for your help in completing the Home Affordability
Worksheet that follows.
To assist in the preparation of the worksheet, Valerie and Shen also collected the following information:
• Their financial records report a combined gross before-tax annual income of $85,000 and current (premortgage) installment loan,
credit card, and car loan debt of $1,240 per month.
• Their property taxes and homeowner's insurance policy are expected to cost $3,488 per year.
• Their best estimate of the interest rate on their mortgage is 7.5%, and they are interested in obtaining a 15-year loan.
They have accumulated savings of $38,500 that can be used to…
arrow_forward
Using the time value of money
Helen wants to take the next four years off work to travel around the world. She estimates her annual cash needs at $31,000 (if she needs more, she will work odd jobs). Helen believes she can invest her savings at 10% until she depletes her funds.
Requirements
How much money does Helen need now to fund her travels?
After speaking with a number of banks, Helen learns she will only be able to invest her funds at 6°/0. How much does she need now to fund her travels?
arrow_forward
Help
arrow_forward
Hi I’m confused about this questions can you help me please?
arrow_forward
pr/4
arrow_forward
The parents of a newborn want to start a savings account for their daughter. They would like to have $20,000 in the account 18 years from now. How much money do they need to invest now in an account that pays 3.5% interest compounded daily, so that they reach their goal?* $16,052.16 $10,652.16 $9,652.16
arrow_forward
What is the amount of Laura’s monthly cash outflows if she chooses to rent the apartment by her herself?
Use the rent amount for the one bedroom apartment to complete her budget?
arrow_forward
Linda wants to buy a new car in a few years. She sets a goal to have $43,950 in her savings account to buy a car. Linda plans to save money for 5 years by making monthly deposits to a saving account at APR 2.5% compounded monthly. Round answer to two decimal places
a. In order for Linda to reach her saving goal. How much will Linda need to save each money
b. Overall Linda contributed how much of her own money into saving account?
arrow_forward
Heather borrowed $4700 on her credit card to purchase new furniture. Find the monthly interest charges, which are 1.8% per month on the unpaid balance. Find the interest charges if she moves the debt to a credit card charging 0.7% per month on the unpaid balance. What are the interest charges at 1.8% a month? What are the interest charges at 0.7% a month? What are the savings that using the 0.7% card brings over the 1.8% card?
arrow_forward
6. Genesus wants to buy a car. Her monthly income is $800, and she already has
a credit card payment of $50 per month. Based on the debt to income ratio
formula, how much in additional (extra) monthly payments can she afford?
arrow_forward
Need help with this question
arrow_forward
QUESTION 1
Tiffany, a self-employed dentist, currently earns $100,000 per year. Tiffany has always been a self proclaimed saver, and saves 25% per
year of her Schedule C net income. Assume Tiffany paid $13,000 in Social Security taxes. Tiffany plans to pay off her home mortgage at
retirement and live debt free. She currently spends $25,000 per year on her mortgage. What do you expect Tiffany's wage replacement
ratio to be at retirement based on the above information?
37.00%.
59.70%.
65.30%.
84.70%.
T
arrow_forward
Merita is shopping for a new car. She checked her budget, and is comfortable with a car payment of $425 per month. She has good credit and hopes to secure a 5-year loan at 3.15% interest. What is the maximum amount she should pay for a car to stay within her monthly payment amount.
A: $ 23,564
B: 25,500
C: $23,250
D: $24,362
arrow_forward
Madeline Rollins is trying to decide whether she can afford a loan she needs in order to
go to chiropractic school. Right now Madeline is living at home and works in a shoe
store, earning a gross income of $960 per month. Her employer deducts a total of $170
for taxes from her monthly pay. Madeline also pays $115 on several credit card debts
each month. The loan she needs for chiropractic school will cost an additional $170 per
month.
Calculate her debt payments-to-income ratio with and without the college loan.
(Remember the 20 percent rule.) (Enter your answers as a percent rounded to 2
decimal places.)
With college loan
Without college loan
Debt Payments-to-
Income
Ratio
arrow_forward
Dengar
arrow_forward
A man wants to set up a 529 college savings account for his granddaughter. How much would he need to deposit each year into the account in order to have $40,000 saved up for when she goes to college in 16 years, assuming the account earns a 4% return.
arrow_forward
2. Suppose Miss Roxanne Davenport is 25 years old right now and puts away $1,800 per quarter in an
account that returns 6% interest.
a.
How much will be in the account when she turns 65?
b.
What is her total contribution to the account?
How much interest did she earn?
arrow_forward
To be able to take her dream vacation, Donna decides to save for 5 years. She opens a savings account with $600. The account pays simple interest at an annual rate of 2%. She doesn't make any more deposits.
1. How much total interest will Donna earn?
2. What will the total amount in the account be (including interest)?
arrow_forward
Solve this problem
arrow_forward
1) Betty Smith (that scoundrel Bob’s wife) wants to save $500,000 in four years. She knows that Bob isno good and is planning on leaving him. She wants to make monthly deposits into an account thatpays 5%monthly. How much should she deposit at the end of each month? For those that are curious,Betty makes money by selling poodle prints. She dips her poodle in a giant ink well and presses it ontoa canvas. Dog lovers will buy anything.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- 3arrow_forwardAccounting Henry makes $13.67/hr. at his job and he normally works 43 hours per week. His expenses each month are $940/month for rent, $529.26/month for utilities, and $410/month for food and clothing. He wants to buy a car, but the payments are $382.74/month. If Henry pays 15% of his income to taxes and insurance, can he afford this new car? Give your answer as the amount of money left after the car payment is added or give a negative number of the money he earns is not enough. Assume a month is 4 weeks. Round to the nearest cent.arrow_forward3. What house value can Betty afford? Betty's annual income is $90,000 and she has monthly credit payments of $500. She is looking for a house financed by 30 year 6% mortgage with 20% down payment. Property tax and insurance on the home is expected to be $300 per month. Calculate the value of the house she can afford.arrow_forward
- Financial accountingarrow_forwardK Estimating the Opportunity Cost. Julia brings home $1,790 per month after taxes Julia's rent is $366 per month, her utilities are 597 per month, and her car payment is $260 per month. Julia is currently paying $231 per month to her orthodontist for her braces Julia's groceries cost $30 per week and she estimates her other expenses to be $167 per month As a result, she has $517 left each month to put toward savings to reach her financial goals Julia is considering trading in her car for a new one Her new car payment will be $348 per month, and her insurance cost will increase by $57 per month Julia determines that her other car-related expenses (gas, oll) will stay about the same. What is the opportunity cost if Julia purchases the new car? The opportunity cost if Julia purchases the new car is 5 (Round to the nearest dollar)arrow_forwardStarting on the day Kelly was born, her mother has invested $50 at the beginning of every month in a savings account that earns 2.20% compounded monthly. a. How much did Kelly have in this account on her 22nd birthday? Assume that there was no deposit on that day. b. What was her mother's total investment? c. How much interest did the investment earn? How much should Diana's dad invest into a savings account today, to be able to pay for Diana's rent for the next five years if rent is $950 payable at the beginning of each month? The savings account earns 3.75% compounded monthly.arrow_forward
- Timothy Mother Ms. Parker find out her Monthly Rent is $496.00 every month but she owes $13,842.00 but she gonna got $6,000 save up in the bank how much more she post to take out to add up to that amount?arrow_forward6) Susan is looking to purchase her first home five years from today. The house costs $1,550,000. She will have to make a down payment of 10% of this amount and plans to take a loan from the bank for the difference. Bank charges are approximately 15% of the loan amount. She plans to start saving from today to cover both the down payment and the bank charges. a. How much will she need to save to cover both the down payment and bank charges? b. If she currently has $195,000 in her account and will make no further deposits over the next five years, what rate of interest must she earn on this account in order to achieve the savings target calculated in part (a) above?arrow_forwardHow much should Bianca's dad invest into a savings account today, to be able to pay for Bianca's rent for the next two years if rent is $850 payable at the beginning of each month? The savings account earns 2.50% compounded monthly Courtney set up a savings fund for his son's education so that he would be able to withdraw $1,600 at the beginning of every month for the next 4 years. The fund earns 4.89% compounded quarterly. a. What amount should he deposit today to allow for the $1,600 periodic withdrawals? $57,837.41 $69,654.42 $69,937.11 $58,544.47 b. How much interest would he earn in this investment? $69,937.11 $6,862.89 $76,800.00 $7,145.58arrow_forward
- 11. Can I afford this home? - Part 1 Can Valerie and Shen afford this home using the monthly income loan criterion? Next week, your friends Valerie and Shen want to apply to the Tenth National Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $155,000. Given your knowledge of personal finance, they've asked for your help in completing the Home Affordability Worksheet that follows. To assist in the preparation of the worksheet, Valerie and Shen also collected the following information: • Their financial records report a combined gross before-tax annual income of $85,000 and current (premortgage) installment loan, credit card, and car loan debt of $1,240 per month. • Their property taxes and homeowner's insurance policy are expected to cost $3,488 per year. • Their best estimate of the interest rate on their mortgage is 7.5%, and they are interested in obtaining a 15-year loan. They have accumulated savings of $38,500 that can be used to…arrow_forwardUsing the time value of money Helen wants to take the next four years off work to travel around the world. She estimates her annual cash needs at $31,000 (if she needs more, she will work odd jobs). Helen believes she can invest her savings at 10% until she depletes her funds. Requirements How much money does Helen need now to fund her travels? After speaking with a number of banks, Helen learns she will only be able to invest her funds at 6°/0. How much does she need now to fund her travels?arrow_forwardHelparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education