Excel File Edit View Insert Format Tools Data Window Help Q @ Sun Jun 9 1:14 PM AutoSave ... FIN 450 Project Template Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share : Calibri (Body) 11 AA B v Accounting Insert v 2 Paste Delete BIU v A ~ % 9 Conditional Format Cell Sort & Find & Format v Add-ins Analyze Formatting as Table Styles Filter Select Data G70 X V fx 13.09 G H M N U.S. Treasury 10-Year Bond Rate 4.42% Profile 1 - Kayla Holding Ticker $ Amount Held In Portfolio Weight Held In Portfolio Last Closing Price 12 Closing Price One Year Prior Last 12 Months Return Risk Adjusted Return Five Year Return Annual Return vs. Appropriate Benchmark Dividend Yield Beta 13 Cash N/A 15,000.00 5.54% N/A N/A N/A N/A N/A N/A N/A N/A Intermediate- Term Treasury 14 ETF VGI 25,000.00 25.91% 57.93 $ 54.21 6.86% 2.44% -0.17% -2% 3% 0.78 Vanguard Total 15 Stock Market ETF VTI 15,000.00 15.54% 262.56 $ 208.19 26.12% 21.70% 12.34% 20% 1% Black Rock Equity 1.01 16 Dividend Fund MADVX 15,000.00 15.54% 20.11 $ 18.76 7.20% 2.78% 7.10% 14% 2% 0.9 17 Johnson & Johson JN 6,500.00 6.74% 154.64 $ 158.48 -2.42% 6.84% 28.23% 0.04% 3% 0.55 18 Pfizer PF 6,500.00 6.74% 28.64 36.48 -21.49% -25.91% 1.59% -18% 6% 0.58 19 Bank of America BAC 6,500.00 6.74% 39.29 $ 28.47 38.00% 33.58% 17.51% 48% 2% 1.38 20 Walmart WMT 3,000.00 3.11% 64.65 $ 50.49 28.05% 23.63% 92.70% 31% 1% 0.49 21 CVS Health CVS 4,000.00 4.15% S 57.68 5 69.31 -16.78% 21.20% 27.57% -11% 50% 0 .7 96,500.00 100.00% Calculations + Ready Accessibility: Good to go 87% 51,809 tvChrome File e Edit View History Bookmarks Profiles Tab Window Help Q 8 @ Sun Jun 9 1:15 PM ... mySN X D21 5-2 M X D2L Milest X FIN 4 X Cours x Home x 5_2_F X Cours X FIN_4 X B Forec: X ACC 3 X G Sumn x + -> C learn.snhu.edu/content/enforced/1610962-FIN-450-12725.202451-1/course_documents/FIN%20450%20Project%20Profiles.pdf?isCourseFile=true&... Update : E FIN 450 Project Profiles.pdf 100% also hopes to open her own practice once her student loans are paid off and would like to build up enough assets, some in more liquid assets, to fund the start-up costs. Another reason for paying down debt and getting her finances in order is to improve her credit score, so she can access business debt funding for her future practice Asset Account Ticker Size ($) Cash Bank Savings N/A $15,000 Vanguard Intermediate-Term 401(k) VGIT $25,000 Treasury ETF Vanguard Total Stock 401(k) VTI $15,000 Market ETF BlackRock Equity 401(k) MADVX $15,000 Dividend Fund Johnson & Johnson IRA JNJ $6,50 Pfizer IRA PFE $6,500 Southern New Hampshire University Asset Account Ticker Size ($) Bank of America IRA BAC $6,50 Walmart Trading/Brokerage WMT $3,000 CVS Health Trading/Brokerage CVS $4,000 Total $96,500 2. Jason and Elizabeth are a professional, college-educated couple. They are both 47 years old and reside in California with their two children. ages 18 and 13. Jason is an attorney who practices 51,809 "tvExcel File Edit View Insert Format Tools Data Window Help Q @ Sun Jun 9 1:14 PM AutoSave ... FIN 450 Project Template Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share : Calibri (Body) 11 AA B v Accounting Insert v 2 Delete Paste BIUV A - V $ Conditional Format Cell Sort & Find & Add-ins Analyze Formatting as Table Styles Format v Filter Select Data G70 X V fx 13.09 B G M O 4,500,000.00 100.00% Market Indices Returns* Holding Ticker 1-Year Return 3-Year Return 5-Year Return 10-Year Return 69 S&P 500 ETF Trust SPY R F 28.33 1008.00% 13.09 S 12.30 Invesco QQQ ETF QQQ 35.87 1241.009 18.29 | $ 18.10 *Used primarily for Milestone Two Calculations + Ready Accessibility: Good to go + 87% 51,809 tvBow [ xf@mae 450 Project Profiles.pd ! (0]0173 I e = FIN 450 Project Profiles 1. Kaylais a 29-year-old single female who just graduated from medical school and is starting her career as a doctor. Her annual salary is $150,000. She wants to pay off her $100,000 student loan debt (average debt rate 6%) quicker, so she reduced her cash savings. She contributes to her employer-provided 401(k) plan at a 6% contribution rate. The employer provides a match on the initial 6% contribution. She knows that the IRS 401(k) maximum contribution of $22,500 in 2023 is expected to rise to $23,000 in 2024. She understands that she is not taking full advantage of the 401(k) contribution tax deferral opportunity since her 6% contribution of $150,000 is roughly $9,000 annually. (For most individuals, every dollar invested in their 401 (k) now means a dollar of income not taxed now and instead taxed later, preferably in retirement when personal taxes are generally lower than the rate in working years.) However, she has contributed to an IRA account annually for a few years, including $6,500 in 2023. She anticipates contributing the 2024 limit of $7,000. Kayla earns too much income to use the IRA contributions as tax deductions, but she does live in Floridaa state with no income taxes. Kayla's reasoning behind her decision to contribute to an IRA account instead of contributing the maximum possible annual contribution to her 401(k) is that her IRA account, which is provided by a national bank, allows her to invest in individual stocks, similar to a traditional brokerage account, while the 401(k) plan allows only for investments in mutual funds, exchange-traded funds, and diversified baskets of stocks and bonds. She also has a trading account with the same bank where she maintains the IRA account. All assets held in the three accounts are listed below. While she is generally conservative when it comes to making risky investments, she has a newfound understanding that growth requires taking risk, and that she can raise her risk profile because of her age and what is expected to be rapidly increasing income throughout her career. Now that she has a full-time job, she plans to increase her retirement savings while maintaining contributions to the IRA and investing in her trading account. She has tried to become more educated about the markets and understands that while prior return does not guarantee future performance, she would like to generate the same annual return as S&P 500 during the last 10 years. Because her expenses are modest, her student loans should be paid off in 10 years. She also hopes to open her own practice once her student loans are paid off and would like to build up enough assets, some in more liquid assets, to fund the start-up costs. Another reason for paying down debt and getting her finances in order is to improve her credit score, so she can access business debt funding for her future practice. Asset Account Ticker Size ($) Jolc)L A 180 1% B ' el e