i did 3 of the work pages on word and from that you will follow the rest for the other pages and on excel.
Instructions Instructions This spreadsheet file contains three worksheets (Taxes, Debt, and Retirement) to assist you with completing your personal financial plan. Click on the tabs below to access each worksheet. You should save this file when complete and submit it to the Dropbox folder on D2L along with your completed personal financial plan Word document. Taxes Taxes This worksheet helps you estimate how much you will owe in federal income tax given the current federal income tax rates effective 2018. Individual TaxpayersIf Taxable Income is Between:The Tax Due is: 0 - $9,52510% of taxable income $9,526 - $38,700$952.50 + 12% of the amount over $9,525 $38,701 - $82,500$4,453.50 + 22% of the amount over $38,700 $82,501 - $157,500$14,089.50 + 24% of the amount over $82,500 $157,501 - $200,000$32,089.50 + 32% of the amount over $157,500 $200,001 - $500,000$45,689.50 + 35% of the amount over $200,000 $500,001+$150,689.50 + 37% of the amount over $500,000 Enter your estimated annual earnings in cell B14 below. Monthly salary, annual taxes, and monthly taxes are calculated automatically. Annual salary:$10,000.00 Monthly salary:$833.33 Annual taxes:$1,009.50 Monthly taxes:$84.13 Debt Debt This worksheet helps you estimate how much you will owe each month on debt, such as credit card balances, car loans, student loan debt, and home loans. Enter the total amount of debt in cell B5 below, the payoff period in years in cell B6 below, and the annual interst rate in cell B7 below. The monthly payment to payoff the debt balance within the payoff period is calculated automatically. Total Debt Balance$10,000 Payoff Period in YEARS10years Annual Interest Rate5% Monthly Payment$106.07 Retirement Retirement This worksheet helps you estimate how much you can accumulate in a retirement account while working and how much you will be able to withdraw each month in retirement. Enter your annual salary in cell B6 below, the percentage of your salary you plan to contribute to your retirement account in cell B7 below, and your estimated years of work in cell B8 below. This example calculates automatically the assumption that your employer will match your contribution up to 5% of your salary if you put in at least 5% of your salary each month. Annaul Salary:$10,000 Your % contribution:4% Years of Work:30years Employer Match:0% Enter the percentages below that you plan to allocate to each category of investments during your working life. You estimated total accumulated balance upon retirement is calculated automatically. Employer Stock:0% Money Market Fund:100% Bond Fund:0% Equity Fund:0% Estimated Balance at Retirement$16,424.18 Enter the number of years you plan to make equal monthly withdrawals from your retirement account. Years of Retirement: 30years Enter the percentages below that you plan to maintain to each category of investments during your retirement years. Your estimated monthly withdrawal amount is calculated automatically. Employer Stock:0% Money Market Fund:100% Bond Fund:0% Equity Fund:0% Estimated Monthly Withdrawals:$60.71 Personal Financial Plan FIN 2010 Personal Financial Planning Name: (Insert Your Name Here) Self-Reflection Briefly answer each of the following questions about yourself. · What are my passions, those things that I have an intense desire or enthusiasm for? To work so much now so that my kids won’ t have to. Along with being truthful and not a fake person. Also, just learning more about myself, and my religion. · What do I do best? At being a great mother, daughter, wife, sister and friend. · What activities do I need to be a regular part of my life? Working out, cooking, cleaning, and hanging out with families. · What gives me energy? My Family · What am I willing to sacrifice for? My time and sleep · Whom do I want to help in life? How can I help them? My family members making sure my brothers are at least stable, because back home its not a easy life. I also want to be able to help my mother so she won’t have to work anymore and can rest. · What do I love to do? Love to cook, clean, travel, being with my family and just relax. Define Your Goals State at least three short-term, three medium-term, and three long-term personal goals. Short-term Goals (Examples: pay off credit card debt, go on vacation) · 1) Finish my last two semester of University · 2) Have a monthly budget · 3)Eliminating my credit Medium-term Goals (Examples: get married, pay off student loans) · 1) Purchasing a house · 2)Get a Job based on my major Economics · 3)Change my car Long-term Goals (Examples: pay for children’s college, retire early) · 1) Having a third child · 2) Working with my husband · 3) Living healthy · Save up for retirement Assess Your Current Financial Situation Provide the details on your current financial situation. Monthly Inflows (Examples: wages $1,000; parental allowance $500) · 1) Work $3,600 · Monthly Outflows (Examples: rent $500, food $300, car payment $350) · 1)Rent $1250 · 2)Car Insurance $96 · Food $500 Assets (Examples: car $10,000; savings $1,000; personal items $2,000) · 1) Car $8,000 · 2) Savings $5000 · Liabilities (Examples: car loan balance $12,500; student debt $35,000; credit card debt $800) · 1) Credit Card $5,800 · 2) Car Loan $3,000 · Describe your payment schedule and interest rate for each liability. (Examples: Equal monthly payments due after graduation for ten years at 6% interest, equal monthly payments of $350 for 20 months remaining) · 1) · 2) · Assess Your Future Financial Situation Likely your future financial situation five years after graduation will be substantially different than your current financial situation. State your future career plans and estimate your annual earnings. Provide the source of your estimates. Need ideas? Check out the Bureau of Labor Statistics career exploration page: https://www.bls.gov/k12/content/students/careers/career-exploration.htm Future Career Plan A: Estimated Annual Income: Source: Future Career Plan B: Estimated Annual Income: Source: Forecast your future monthly inflows and outflows five years after graduation based on your career plan A. State your sources. Use the FIN 2010 ‘Personal Financial Plan’ spreadsheet file to help you with estimating monthly expenditures on debt and taxes. Don’t forget to include taxes, insurance, transportation, food, and utilities in your monthly outflows. Monthly Inflows (Examples: wages $3,500; investment income $200) · 1) · 2) · Monthly Outflows (Examples: house payment $1,000; student debt payment $400) · 1) · 2) · Sources: Preparing for the Unexpected For each of the following life circumstances, state how you will prepare in advance to address each situation financially. · An unexpected $300 expense · Your wallet or purse is stolen and you discover there are fraudulent charges on your credit card · A car accident results in $5,000 in damages and six weeks out of work · Strong storms cause approximately $20,000 damage to your home · A medically necessary surgery with three days of hospitalization · Unexpected early death Investing for the Long Run Many employers provide a retirement benefit, such as a 401(k) account, and may provide matching contributions into your account. State your planned choice in each situation. · Your employer provides a traditional 401(k) account; however, no matching funds are provided. What percentage of your salary per month do you plan to contribute? · Your employer provides a traditional 401(k) account and will match your contribution up to 5% of your salary if you put in at least 5% of your salary each month. What percentage of your salary per month do you plan to contribute? · Your employer provides a menu of low-fee investment options for your 401(k) account that include the employer stock, a money market fund, a mutual fund specializing in government bonds, and a mutual fund that invests in both domestic and international stocks. What percentage of your monthly contribution will you allocate to each option? · employer stock: · money market fund: · bond fund: · equity fund: · Your employer begins providing a Roth 401(k) account as an alternative to the traditional 401(k) account. Will you switch your monthly contribution to a Roth account? Why or why not? · Use the FIN 2010 ‘Personal Financial Plan’ spreadsheet file to help you with estimating how much your retirement account will reach by the start of your retirement. estimated retirement account balance at retirement: · Use the FIN 2010 ‘Personal Financial Plan’ spreadsheet file to help you with estimating how much your retirement account will be able to produce in income each year of your retirement. estimated retirement account yearly withdrawal: