FINA 200 Case 1 Winter 2023

docx

School

Concordia University *

*We aren’t endorsed by this school

Course

200

Subject

Finance

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by LieutenantOwlPerson1010

© May not be copied or duplicated without the permission of the owner. FINA 200 - Personal Finance © Case 1 Winter 2023, Section EC Case 1 (due March 17, 2023, before 11:59 p.m. ET) Covering Chapters 1 – 7 Student Name: Student ID: PLEASE NOTE INSTRUCTIONS BELOW  Write your name and student ID above.  This is an individual assignment, to be completed by you alone.  There are 11 pages to this Case including the cover page – please ensure that you have all 11 pages.  Case 1 consists of two sections . Answer:  Section I: respond directly on the Case and highlight as well as underline your response to the multiple-choice questions.  Section II: respond directly on the Case in the space provided for each Mini- Case question.  You may submit your solution in English or French; a cceptable submission formats include Word (.docx or.doc) or PDF. EXCEL is NOT accepted.  Ensure that all responses with calculations are to two decimal places .  Tables can be found at the end of the Case to help respond to some of the questions . Outside research will be required (research does not require citations). This Case is 20% of your grade. For marking purposes only: Multiple Choice Mini-Case A Mini-Case B Mini-Case C Mini-Case D Mini-Case E Total /5 /2 /1.5 /6 /1.5 /4 /20 1

© May not be copied or duplicated without the permission of the owner. Section I: Five (5) Multiple-Choice Questions (5 marks - 1 mark each) Highlight AND underline your response . 1) Samantha and Samuel both have student credit cards issued by VISA. Their credit card statements show they are at their credit card limit of $500 this month. Samantha manages her credit well and ensures that her credit card balance is paid off in full each month before the payment deadline while Samuel cannot manage to pay off the minimum amount required each month. Complete the sentence: For Financial Statement reporting purposes, __________________________________________. a) It does not matter where Samantha or Samuel report the $500 as long as it is shown on one of their Financial Statements. b) Both Samantha and Samuel would report their $500 on their Balance Sheet as a current liability. c) Both Samantha and Samuel would report their $500 on their Cash Flow statement as an expense. d) Samantha would report her $500 on her Cash Flow statement as an expense while Samuel would report his credit card debt of $500 on his Balance Sheet as a current liability . e) Samantha would report her $500 on her Balance Sheet as a current liability while Samuel would report his credit card debt of $500 on his Cash Flow statement as an expense. 2) Geneviève is in her first year at Concordia. She is originally from Quebec City but lives near the university in downtown Montreal during the school year. She has been approached by the Bank of Montreal for a BMO Cashback Mastercard for students for her first credit card. What would be Geneviève’s effective interest rate on her credit card if she took a cash advance? Hint: use the credit card details below as well as 365 days for compounding. a) 25.85% b) 24.59% c) 23.67% d) 24.47% e) 26.32% 2

© May not be copied or duplicated without the permission of the owner. 3) Shelly just graduated from Concordia in December 2022 and started her full-time employment as of January 2023. She has asked you to help her calculate her taxable income for 2023 based on the following:  Employment income (gross): $72,000  Interest income: $500  Unused tuition carry over from 2022: $6,000  Engineering professional dues: $1,200  Annual union dues: $550  RRSP contribution: $3,000  TFSA contribution: $2,000  Sold 300 shares in XYZ company at $32 per share on January 10, 2023 (paid a total of $8,700 for 600 shares when she purchased them in 2022)  Net capital loss from other years of $1,400 a) $66,525 b) $61,525 c) $68,975 d) $68,700 e) $66,975 4) Maryse contributes $1,000 of her pre-tax income to her employer’s Group Registered Retirement Savings Plan (RRSP). Her employer will match her contribution to her Group RRSP. Ignore income taxes. Her disposable income will then: a) Decline by $1,000 b) Increase by $1,000 c) Decline by $2,000 d) Increase by $2,000 e) Remain the same 5) Jax and Jackie are signing their mortgage today with regards to the purchase of their first condo. As they have no other savings other than their Registered Retirement Savings Plan (RRSP), they are required to participate in the Home Buyers Plan (HBP) for the entire down payment. To date, Jax has contributed $25,700 while Jackie has contributed $41,200. At the beginning of the year on January 1, 2023, the market value of their RRSP’s was $43,890 for Jax and $52,310 for Jackie. With the recent downturn in the markets, as of today, the market value of Jax’s RRSP is $34,150 and Jackie’s is $35,350. They need to let the bank know today how much they have for a down payment. What is the maximum amount they can withdraw from their respective RRSP’s to put towards their down payment on a home under the HBP? a) $70,000 b) $69,500 c) $66,900 d) $96,200 e) $69,150 3

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

© May not be copied or duplicated without the permission of the owner. Section II: Five (5) Mini-Cases (20 marks) Write your response in the template or space provided. Mini-Case A: (2 marks) Cindy graduated from Concordia in December 2021 and started her full-time job in January 2022 with a salary of $80,000. She never worked until her first job in 2022 but knew from her FINA 200 course to file a tax return throughout her university years to record her tuition so as to carry the tuition amounts forward to claim in future years when she would have income. The year 2022 will be the first year that Cindy claims the tuition non-refundable tax credit due to her employment income. Cindy’s Federal tuition tax credit in 2021 was $4,200, (same for 2020 and 2019 for total tuition carryforward of $12,600). See Cindy’s Concordia 2021 tuition tax slip T2202 below which she filed in her 2021 tax return (and was the only line item in her personal tax return as she had no income; the same zero tax filing was done in 2019 and 2020, to record the tuition amounts only). a) In 2022, Cindy’s employer did not withhold sufficient income taxes and Cindy owes $2,000 to Canada Revenue Agency (CRA) on her 2022 Federal personal tax return. How much tuition can Cindy claim on her 2022 Federal personal tax return? (.25 marks) $ ____12600_______ 5

© May not be copied or duplicated without the permission of the owner. b) In 2022, Cindy’s father owed $5,000 to Canada Revenue Agency (CRA) on his 2022 Federal personal income tax return so he asked Cindy to transfer her tuition tax credit and to provide him with her T2202 tax slip from Concordia. How much tuition can Cindy transfer to her father for him to use on his 2022 Federal personal income tax return? (.25 marks) $ ___________0_________________ c) Complete the sentences regarding Federal tuition: (1.5 marks - .25 marks each) In general, a student may transfer a maximum of $____5000 _ of the current year’s federal tuition amount. Who can claim unused tuition credits (either all or some of the remainder not claimed)? ____ spouse/ common-law partner ___, or __ parent ___, or _____ grandparent ______, or __ your spouse's or common-law partner's parent ____ or _____ grandparent _____. Mini-Case B: (1.5 marks) Lori is 45 years old and has always contributed the maximum to her Tax-Free Savings Account (TFSA) on each January 1 st since the program started in 1999. As of January 1, 2023, she has contributed a total of $88,000 which includes the latest contribution of $6,500, for a total market value of $234,590! If Lori continues to contribute $6,500 each January 1 st until her retirement in 20 years, how much will she have in her TFSA where she expects to earn 6% compounded weekly? Assume that we are January 1, 2023, and that TFSA contributions continue on each January 1st at $6,500 until Lori’s retirement. Calculate Lori’s TFSA at retirement: (1.5 mark) P/Y = 1, C/Y = 52, N = 20, I/Y = 6, PV = 234,590, PMT = -6500, FV = ? BGN mode She will have $1,037,177.92 in her TFSA when she retires in 20 years. Mini-Case C: (6 marks - .5 marks each) Michael turned 25 years old on March 1, 2023, and just opened a Tax-Free Savings Account (TFSA) where he deposited $6,500. Help Michael with the scenarios below. Michael is aware of the following basics regarding TFSA’s:  you can withdraw any amount from your TFSA whenever you want;  all withdrawals are tax-free;  withdrawing from your TFSA doesn’t result in lost TFSA contribution room;  withdrawals you make this year will be added to your unused contribution room the following year (i.e. withdrawing from your TFSA has no effect on your contribution room in the year that you make the withdrawal, it only affects your contribution room for the following year); 6

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

© May not be copied or duplicated without the permission of the owner.  you can re-contribute any funds that you have withdrawn from your TFSA back into your account starting the year after the year in which you make the withdrawal (i.e. January 1 st of the following year); and  you can carry forward any uncontributed amounts into future years indefinitely. a) If Michael’s $6,500 TFSA investment decreases due to a downturn in the market to $4,000 which he then withdraws, how much can Michael recontribute? (ignore carry forward contribution room) (.5 marks) $__4000 ___ b) If Michael’s $6,500 TFSA investment increases to $8,000 which he then withdraws, how much can Michael recontribute? (ignore carry forward contribution room)? (.5 marks) $____8000 ___ c) Michael’s friend, John just turned 23 on February 28, 2023. He recently opened a TFSA account but has yet to make a TFSA contribution. How much can John contribute to his TFSA (consider carry forward contributions). $__36000 ____ (.5 marks) d) Michael’s younger brother, Sam is trying to understand his TFSA available contribution room to ensure that he does not go over the limits. Complete the TFSA Available Contribution Room Table below. (2.5 marks - .5 marks each) TFSA Available Contribution Room Table Date TFSA Available Contribution Room February 28, 2021 Sam turned 18 and opened a TFSA $_ 6000 __ contribution room in 2021 January 1, 2022 New contribution room available $_ 6000 __ contribution room in 2022 May 23, 2022 Contributes $12,000 $___0 _ contribution room in 2022 September 1, 2022 Withdraws $1,000 $___0 ____ contribution room in 2022 Jan. 1, 2023 New contribution room available $__7500 contribution room in 2023 e) Sam wants to know what would happen if he over contributed to his TFSA? (.5 marks) _____Sam would have to pay tax on equal to 1% of the highest excess TFSA amount in the month, for every month there is an excess amount that stays in the TFSA account. _____________________________________________________________________________ _____________________________________________________________________________ ________________________________________________________________________ f) Michael’s father has never made any TFSA contributions since the program started in 2009 except for this year’s contribution of $6,500. What is the maximum amount that he can contribute to his TFSA as of March 2023? Do not forget to consider contribution room from previous years. (.5 marks) Contribution room amount for Michael’s father: (.5 marks) The cumulative TFSA contribution limit from 2009 to 2023 for Michael’s father is $88,000. Since his father has contributed $6,500 in 2023, the maximum he can contribute to TFSA as of March 2023 would be $81,500 (88,000-6,500). 7

© May not be copied or duplicated without the permission of the owner. g) Michael has heard of some Canadians that are millionaires with their TFSA’s. If that were the case and they withdrew $1 million dollars from their TFSA account, how much tax would they pay on the withdrawn funds if they were in a 53.31% marginal tax bracket? (.5 marks) Tax calculation on $1 million TFSA withdrawal: (.5 marks) Withdrawals are not taxable as they are not considered as earned income. Therefore there is not tax payable on the amount. h) Michael wants to know in point g), if the taxpayer withdrew $1 million dollars from their TFSA account, how much could they re-contribute to their TFSA the following year? Ignore previous year’s and 2024 contribution room. (.5 marks) $___1 million____ _ Mini-Case D: (1.5 marks) Gerry is a resident of Quebec and has been with the same employer, XYZ company for the last 3 years. Facts:  Gerry’s gross salary in 2022: $96,000  ignore non-refundable tax credits for this problem a) Using Table A, 2022 tax rates, calculate Gerry’s taxes payable (1 mark) Gerry’s Taxes Payable (1 mark) 2022 Taxable Income Marginal rate Taxable Income Taxes Payable first $46,295 27.53% $46,295.00 $12,745.01 over $46,295 up to $50,197 32.53% $3,902.00 $1,269.32 over $50,197 up to $92,580 37.12% $42,383.00 $15,732.57 over $92,580 up to $100,392 41.12% $3,420.00 $1,406.30 Gerry’s taxes payable $96,000.00 $31,153.21 b) Calculate Gerry’s average tax rate and marginal tax rate. (.5 marks) : Tax calculation Average tax rate (.25 marks) 31,153.21/ 96,000 = 32.45% Marginal tax rate (.25 marks) 41.12% 8

© May not be copied or duplicated without the permission of the owner. Mini-Case E: (4 marks) Eva and Jorge just received the call from their real estate agent that their offer of $350,000 was accepted on a Montreal condo! Money will be tight since it took all their savings for a 10% down payment. They are trying to monitor their costs to avoid any surprises. The Canada Mortgage Housing Corporation (CMHC) mortgage loan insurance premium is 3.10% of the mortgage amount which they have decided to pay at the time of closing instead of adding it to their monthly mortgage. Other fees include a $650 bank appraisal fee, a $800 home inspection fee, $1,800 notary fees, land transfer tax (also known as the “Welcome tax” or “Transfer duties” – see table below) and $850 for title insurance and homeowner’s insurance of $1,000. https://montreal.ca/en/articles/how-property-transfer-duties-are-calculated-9279 a) How much will Eva and Jorge need to cover at closing including the down-payment? (2 marks) Calculation: (2 marks) Total Down payment - 10% of $350,000 $35,000 CMHC - $350,000*90%*3.1% $9,765 Bank appraisal fee $650 Home inspection fee $800 Notary fees $1,800 Land transfer tax (see Note 1) $3,593 Title insurance $850 Homeowner’s insurance $1,000 Amount to be covered at closing $53,458 9

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

© May not be copied or duplicated without the permission of the owner. Note 1 Tax base value Tax base Rate Property transfer duties Up to $55,200 $55,200.00 0.5% $276.00 $55,200 to $276,200 $221,000.00 1.0% $2,210.00 $276,200 to $552,300 $73,800.00 1.5% $1,107.00 Total $350,000.00 $3,593.00 b) Complete the sentence: Eva and Jorge do not have a conventional mortgage as they do not have the 20% down payment. (.25 marks) c) Eva and Jorge’s bank just called as they calculated their Gross Debt Service (GDS) ratio as 32%, how much will the monthly mortgage payment be based on this ratio? Eva’s gross annual income is $120,000 while Jorge’s is $115,200. The monthly heating would be $475, condo fees of $800 per month, and annual property taxes would be $3,600 along with monthly debt payments of $1,755. (1 mark) Calculation: (1 mark) monthly mortgage payment + $475 + $3,600/12 + $800 = 32% ($120,000+$115,200)/12 monthly mortgage payment = $4,697 d) Eva decided to buy a house with Jorge, even though she knows he is terrible with money and has a poor credit score. Eva has always been a saver while Jorge is a big spender which is why they only have 10% as a down payment and require mortgage loan insurance, which Eva had hoped to avoid. They also have a high interest rate on their mortgage due to his poor credit card management (i.e. at capacity as he only pays the minimum amounts each month). Provide Jorge with 3 ways that he can improve his credit score: (.75 marks-.25 marks each) 1) He should review his credit report from each of the credit bureaus at least once a year and inform the bureaus if there are any errors._________ _____________ _______ 2) He should also try to make the payments on time and make sure there is no late payment.________________________________________ _________________ 3) He can reduce his debt level by paying more than minimum payments each month. The End Good luck! 10

© May not be copied or duplicated without the permission of the owner. TABLE A TABLE B TABLE C Tax-Free Savings Account (TFSA): Annual Limits Years Annual Limit Years Annual Limit Year started 2009 - 2012 $5,000/year 2016 - 2018 $5,500/year 2013 - 2014 $5,500/year 2019 - 2022 $6,000/year 2015 $10,000/year 2023 $6,500/year (estimated) TABLE D Registered Reti rement Savings Plan (RRSP): Annual Limits Formula for RRSP contributi on limit: 18% of your previous year's earned income less your previous year's pension adjustment to an annual maximum. Year Annual maximum contribution limit 2020 $26,500 2020 $27,230 2021 $27,830 2022 $29,210 11

© May not be copied or duplicated without the permission of the owner. TABLE E Home Buyer’s Plan (HBP)  Withdraw up to $35,000 per borrower and up to $70,000 per couple.  15 years to pay back the amount withdrawn TABLE F Time Value of Money Formulas Simple Interest Future (FV) of a single dollar amount Present Value of a single dollar amount Future Value of an annuity Present Value of an annuity Interest Rate Conversion Time Value: FV = Maturity value or Future value PV = Principal or Present value PMT = Periodic annuity payments n = Number of compounding periods per year i = Annual interest rate t = Time (in years) EY = Effective yield Simple interest: I = Interest earned P = Principal or Present Value r = annual interest rate t = time (in years) 12

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version