TVM and Tax questions

TVM and Tax questions Assignment 1 Instructions: Each group must submit the assignment to the instructor at the beginning of class on the date the assignment is due. When completing your assignment, please observe the following rules and guidelines: 1. Textual portions must be typed and double-spaced. This does not include variables, labels and brief notes of explanation. Use at least one inch margins all around. 2. Double-sided is preferred, if you can do it with your printer. 3. Use 8 ½ X 11 paper only. 4. Do not use report covers. 5. Staple your assignment prior to handing it in. 6. Be sure to write clearly your names, student numbers, section, and due date on the cover page. 7. Spelling and grammar will affect your marks. 8. No assignments will be accepted after the last class. Problem #1: Tax Planning (40 marks) You will need to find specific information, including basic personal tax credit amounts, specific tax credit allowances and 2014 tax brackets from the Canada Revenue Agency website (http://www.cra-arc.gc.ca). The following information is for Monique Cadieux, a single mom with two children (ages 6 and 9) who lives in Collingwood, Ontario. Monique is a grade 5 teacher at a local French immersion school earning an annual salary of $72,000 a year. She would like some help filing her taxes and has documented everything she thinks should be included below: • She received child support payments from the children’s father totaling $9600. • She received spousal support pursuant to a separation agreement totaling $12,000 for the year. • She contributed $8,000 to her RRSP in 2014; her total RRSP account has $77,590. • In her investment account, she sold her shares in the Canadian Banks because she was concerned about their heavy involvement in mortgage lending and oil. o She sold 500 shares TD $50.76. The costs basis for these shares was $44.50. o She sold 200 shares RY $75.52. The costs basis for these shares was $65.55. o She sold 300 shares BNS $60.58. The costs basis for these shares was $50.01. o She sold her 500 shares in ENB at a loss. The cost basis for the shares $56.90 and she sold them for $52.55 o Before selling her bank stocks, each paid out dividends as follows: TD paid $1.50/share, RY paid $2.00/share, BNS paid $.95/share and ENB $.60. • She has a non-registered savings account with TD. She earned $260 in interest during the year. She also has a TFSA that earned $120 in interest 2 • She made a charitable contribution to United Way for $500. • Both of her children played in a hockey league for which she paid $600 for the year ($300 per child). Her daughter took up skate skiing which cost $800 for the year. Her son took cello lessons for which she paid $400. There were also both enrolled in art camp for the summer which cost $1000 ($500 for each child). In addition, tennis lessons for both children cost her $400 ($200 per child). Assume all of these expenses are “eligible” for the purposes of the CATC (http://www.craarc. gc.ca/gncy/bdgt/2011/qa01-eng.html) and the Children’s Fitness Amount (http://www.craarc. gc.ca/fitness/) • She paid $4500 in child care expenses for the year. • Her son got braces for which she paid $1800 to the orthodontist and daughter needed new eyeglasses for which she paid $325. 1) Using the information above, answer the following questions: a) What is her total taxable income (not including investments)? (3 marks) b) What is the total amount of her federal tax credits? You can use Form T1, Schedule 1 (Appendix A of this assignment) to calculate her tax credits. Note that you can use the form, but it is not required. (10 marks) c) What is the total amount of her federal taxes paid (excluding investments)? (4 marks) d) What is her marginal federal tax rate? (1 mark) 2) Calculate her provincial taxes. You do not have to calculate her provincial tax credits, but assume they total $1400 for the year. a) What are her total provincial taxes paid? (4 marks) b) What is her marginal provincial tax rate? (1 mark) 3) How much tax does she pay on her investment income and interest in 2014? (15 marks) 4) What is the total amount of taxes she paid for the year? (1 mark) 5) What is her average tax rate? (1 mark) 3 Problem 2: Retirement Planning (25 marks) Muhammad Sheikh has taken a personal finance class so he knows the benefits of saving early for retirement. He wants to know how much he should be saving each year from his paycheck so that he will be ready for retirement at in 40 years. He has no savings to speak of and makes $60,000 a year. He expects raises of 2% each year for the next 7 years at which point he thinks he will be promoted to middle management which comes with a 25% pay raise. After that, he expects to continue with his 2% raises until he retires (last day of year 40). His company has a forced 10% retirement savings plan, so he will contribute 10% of his salary each year. He estimates that he will need 70% of his final year salary to live on in retirement and expects to live for 20 years after he retires. Assume his savings deposits occur each year at the end of the year and his retirement withdrawals occur each year at the start of the year. This means he makes his last retirement deposit the day he retires (last day of year 40), and then makes his first withdrawal on the first day of year 41. He then makes 20 withdrawals at the start of each year until he hopes he dies with not a penny to his name. He earns 3% nominal on his investments before tax, and everything in this problem is calculated in nominal pre-tax dollars. Assume inflation in his retirement years will be 1.5% a) How much does Muhammad need to have saved by his retirement date at Age 68? (8 marks) b) How much will Muhammad have saved by the time he is 68? (8 marks) c) Will Muhammad achieve his goal? If not, provide Muhammad with three alternatives to help him achieve his goal. The alternatives must be both reasonable and specific. (9 marks) 4 Question 3: Car Financing (25 marks) Use the following information to find the best deal on a new car. You are interested in buying a Honda Civic and have looked around for the best financing deals. For each of the scenarios below, calculate the total finance charges and total cost of ownership. Assume you have an investment account earning an 8% EAR, where you can invest any money that is not going to car payments. Note that for each option, the total amount financed is the price of the car plus the destination charge. You must also include HST (13% in all calculations where HST is applicable – and it’s pretty much applicable on all charges). 1. A financed price of $18,750, plus $1,495 destination charge. The dealer will offer financing at .99% EAR, compounded monthly, for 36 months. At the time of the loan you also owe $147.85 in fees, which will not be financed but due at the time you take the car off the lot. Payments are due at the start of the month. 2. A cash purchase price of $17,795, plus $1495 destination charge. Assume you do not have the cash set aside to pay for this, so will need to get financing from a bank at a rate of 6.5% EAR, compounded monthly and will finance the car over 3 years (36 months). At the time of the loan you also owe $147.85 in fees. Payments are due at the start of the month. 3. You can choose to lease the car with the same purchase price as the financed option ($18,750). Fees associated with the lease include the same destination change ($1,495), a lien registration fee ($27.85), and license/transfer fee of $120. The monthly payment will be $321.56 for 36 months and the residual value is $11,085.20. Find the total cost of each option (show your analysis), choose one of the options and justify your answer. Protected B when completed T1-2014 Federal Tax Schedule 1 Complete this schedule, and attach a copy to your return. For more information, see the related line in the guide. Step 1 – Federal non-refundable tax credits Basic personal amount claim $11,138 300 1 Age amount (if you were born in 1949 or earlier) (use the federal worksheet) (maximum $6,916) 301+ 2 Spouse or common-law partner amount (attach Schedule 5) 303+ 3 Amount for an eligible dependant (attach Schedule 5) 305+ 4 Amount for children born in 1997 or later 366 Number of children for whom you are not claiming the family caregiver amount × $ = 5 352 Number of children for whom you are claiming the family caregiver amount × $ = + 6 367 7 Add lines 5 and 6. = + Amount for infirm dependants age 18 or older (attach Schedule 5) 306+ 8 CPP or QPP contributions: 308 •9 through employment from box 16 and box 17 of all T4 slips (attach Schedule 8 or Form RC381, whichever applies) + on self-employment and other earnings (attach Schedule 8 or Form RC381, whichever applies) 310+ •10 Employment insurance premiums: through employment from box 18 and box 55 of all T4 slips (maximum $913.68) 312+ •11 on self-employment and other eligible earnings (attach Schedule 13) 317+ •12 Volunteer firefighters' amount 362+ 13 Search and rescue volunteers' amount 395+ 14 363 15 Canada employment amount (If you reported employment income on line 101 or line 104, see line 363 in the guide.) (maximum $1,127) + Public transit amount 364+ 16 Children's fitness amount 365+ 17 Children's arts amount 370+ 18 Home buyers' amount 369+ 19 Adoption expenses 313+ 20 Pension income amount (use the federal worksheet) (maximum $2,000) 314+ 21 Caregiver amount (attach Schedule 5) 315+ 22 Disability amount (for self) (claim $7,766 or, if you were under 18 years of age, use the federal worksheet) 316+ 23 Disability amount transferred from a dependant (use the federal worksheet) 318+ 24 Interest paid on your student loans 319+ 25 Your tuition, education, and textbook amounts (attach Schedule 11) 323+ 26 Tuition, education, and textbook amounts transferred from a child 324+ 27 Amounts transferred from your spouse or common-law partner (attach Schedule 2) 326+ 28 330 29 Medical expenses for self, spouse or common-law partner, and your dependent children born in 1997 or later Enter $2,171 or 3% of line 236 of your return, whichever is less. – 30 Line 29 minus line 30 (if negative, enter "0") = 31 331 32 Allowable amount of medical expenses for other dependants (do the calculation at line 331 in the guide) + 332 33 Add lines 31 and 32. = + Add lines 1 to 4, 7 to 28, and line 33. 335= 34 Federal non-refundable tax credit rate × 35 Multiply line 34 by line 35. 338= 36 Donations and gifts (attach Schedule 9) 349+ 37 Total federal non-refundable tax credits 350 38 Add lines 36 and 37. Enter this amount on line 50 on the next page. = Go to Step 2 on the next page. 5000-S1 2,255 4,313 15% Protected B when completed Step 2 – Federal tax on taxable income Enter your taxable income from line 260 of your return. 39 Complete the appropriate column depending on the amount on line 39. Line 39 is $43,953 or less Line 39 is more than $43,953 but not more than $87,907 Line 39 is more than $87,907 but not more than $136,270 Line 39 is more than $136,270 Enter the amount from line 39. 40 – – – – 41 Line 40 minus line 41 (cannot be negative) = = = = 42 × × × × 43 Multiply line 42 by line 43. = = = = 44 + + + + 45 Add lines 44 and 45. = = = = 46 Go to Step 3. Go to Step 3. Go to Step 3. Go to Step 3. Step 3 – Net federal tax Enter the amount from line 46. 47 Federal tax on split income (from line 5 of Form T1206) 424+ •48 404 49 Add lines 47 and 48. = 350 50 Enter your total federal non-refundable tax credits from line 38 on the previous page. Family tax cut (attach Schedule 1-A) 423+ •50A Federal dividend tax credit 425+ •51 Overseas employment tax credit (attach Form T626) 426+ 52 Minimum tax carryover (attach Form T691) 427+ •53 54 Add lines 50 to 53. = – Line 49 minus line 54 (if negative, enter "0") Basic federal tax 429= 55 Federal foreign tax credit (attach Form T2209) 405– 56 Line 55 minus line 56 (if negative, enter "0") Federal tax 406= 57 409 58 Total federal political contributions (attach receipts) 410 •59 Federal political contribution tax credit (use the federal worksheet) (maximum $650) Investment tax credit (attach Form T2038(IND)) 412+ •60 Labour-sponsored funds tax credit Net cost 413 Allowable credit 414+ •61 416 62 Add lines 59, 60, and 61. = – 417 63 Line 57 minus line 62 (if negative, enter "0") If you have an amount on line 48 above, see Form T1206. = 415 •64 Working income tax benefit advance payments received (box 10 of the RC210 slip) + Special taxes (see line 418 in the guide) 418+ 65 Net federal tax 420 66 Add lines 63, 64, and 65. Enter this amount on line 420 of your return. = 5000-S1 See the privacy notice on your return. 0.00 43,953.00 87,907.00 136,270.00 15% 22% 26% 29% 0.00 6,593.00 16,263.00 28,837.00 PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT :)