Personal Finance

Update your winning and losing personal portfolios and the VFINX portfolio with the current stock prices.  Take what you  originally gave me and add a column for the current price of each stock.  Multiply the current price time the number of shares you bought and put the current value in another column.  Total the amount in your portfolios.

Did you make or lose money so far?

Your work might look like this now.

Winning Portfolio

Stock        Beginning Price    Amount Bought    Shares Bought      Price on 1/25    Value on 1/25      Price on 4/30    Value on 4/30    Change in Value
Apple            $100                    $20,000                    200                            $99                  $19,800                $101                $20,200        $400
Microsoft        $32                    $20,000                    625                            $35                   $21,875                $33                  $20,625      -$1,250
AT&T              $42                    $20,000                    476                            $43                   $20,468                $40                  $19,040      -$1,428
Alphabet         $93                    $20,000                   215                            $92.51              $19,889                $90                  $19,350      -$539 
Ford                $22                    $20,000                   909                            $21.53              $19,570                $22                  $19,998        $428
________________________________________________                                                                                                                                                
Total                                          $100,000                                                                              $101,603                                      $99,213        -$2,390

If you are using the portfolio app, you may take screen shots of each portfolio and paste it into Word.  Show the initial value as well as the current value.

Analysis

What are you observing relative to your 3 portfolios?  Have they gained in value or lost?  How do they compare? 

What have you learned from doing this?

Deliverable

Excel workbook or Word document with all three updated portfolios and analysis.

Grading Rubric:

  A B C D F
Professionalism Typed, stapled, no spelling or grammar errors.  Easy to read statements.
Typed, stapled, no spelling, minor grammar errors.  Easy to read statements.
Typed, stapled, minor spelling, grammar errors.  Easy to read statements.
Not stapled, spelling and grammar errors  Statements are not clear.
Not typed or stapled.  Grammar and spelling errors.  Statements are not clear.
Portfolios Updated all stocks with current values.
Show totals for all portfolios.
Show comparison to original purchase values.
Updated all stocks with current values.

Show totals for all portfolios.
Updated all stocks with current values. Updated some stocks with current values. No thought.
Analysis Discusses why you the portfolio values changed the way they did.
Compares the three portfolio results.
Discusses why the three portfolios did what they did relative to each other.
Discusses why you the portfolio values changed the way they did.

Compares the three portfolio results.
Compares the three portfolio results. Just shows the numbers. No thought.