Total Cost of the Car is $

To calculate your monthly car payment, use 5% financing.  Using the PMT function on the spreadsheet, calculate your monthly car payment.   The formula result should match the calculation from Yahoo! Autos.
 

            Monthly Car Payment is                       $

           Monthly Car Insurance is                     $ ___      95.00___     

            Monthly Gas Cost is                            $      ___ 30.00___

           Total Monthly Transportation             $

If you aren’t purchasing a car, you need to pay for Public Transportation.

Monthly Transportation Cost is $     _ 48.00____

After entering transportation costs in your spreadsheet,
please submit Step #3