Personal Finance Simulator 2014    
Version 24.3
David E. Lee, DVM, MBA
Associate Professor, Practice Management
College of Veterinary Medicine
University of Minnesota
      Disclaimer - This program is intended to illustrate basic concepts of personal finance. In the interest of simplicity, many elements have been ignored because of immateriality or irrelevance to the program's intended purpose, As such, the results generated may lack the accuracy desired for serious financial planning. The user is referred to a CPA, CFP, or other qualified professional for such purposes.    
VPINW_Logo        
© 2014, Practice in Practice Management Case Studies, All rights reserved.  
 
Personal Finance Simulator  
Instructions*  
Links across the top of the page walk you through the 8 steps needed to develop a personal budget
1111111111111 1) Student Loan Debt Calculate your monthly payment for any student loans you may have
2) Salary Predict your salary based on productivity. Other sources of income can be entered too.
3) Credit Cards Credit card debt can be a drain on your budget
4) Auto Lease vs Buy Determine whether a new car makes sense for you
5) Home Expenses A new home can be a good investment but a huge liability as well
6) Retirement Savings Saving for retirement is essential but challenging for many new grads
7) Personal Savings Saving for a rainy day is more than just an old adage!
8) Summary Estimate your monthly expenses for the categories provided. Be sure to enter your marital status and exemptions for tax purposes. Scroll down to the bottom to see if you have money leftover!
9) Analysis See how your expenses compare to recommended levels
Beige cells require your input
Dark Blue cells are calculated from other sheets
  IMPORTANT:Input (beige) cells which do not apply should be left blank or you may enter a value of zero ("0"). Include all sources of income, including that from a spouse or partner on the salary page.    
VPINW_Logo * Students using this program with Dr. Wilson's course should also refer to his supplemental instructions
"Reset" will return the values to their default
"Print" will print the current sheet
"Update" will recalculate the worksheets with any changes
(clicking on another cell will do the same thing!)
© 2010, Practice in Practice Management Case Studies, All rights reserved.  
 
    Salary Calculator
Help              
Inputs:
Outputs:
Reality:
Days per Week
Part-time positions are becoming common in veterinary medicine. While such hours may be necessary or desirable for personal reasons, part-time practice can make case continuity and professional growth more challenging. On the other hand, working long hours six or seven days a week for an extended period of time can contribute to burnout and be counterproductive in the long run.
11111 Hours/Day
Vacation/Sick/CE Days/Year
Days Worked per Year
Appointments per 8 Hour Day
Experienced small animal clinicians in busy, efficient practices with proper staffing may see 20 or more cases in an average 8 to 10 hour work day. A new graduate may struggle with more than 12 per day for the first few months. Some practices prefer to see fewer cases (e.g. 8/day) but charge more for their time.
Visits per Year
Doctor ACT
Overall practice Average Client Transactions (ACTs) serve as an important metric of production. A small animal associate's Dr. ACT (total doctor revenue divided by number of doctor produced invoices) varies from a low of $120/case to a high of $225. The national average Dr. ACT is about $180. These numbers are significantly higher for emergency and referral practices where $250 to $500 are common numbers. The ACT for an entire practice is always lower because of sales of pet food, Rx refills, retail items, and any other OTC products.
Sales Req per Year
% of Production
According to NCVEI data from over 12,000 veterinary practices, over 50% of them have a production-based compensation component. Percentages in small animal practices vary from 18% to 22% of production plus benefits while large animal practices average about 25% plus benefits. Check on the willingness to negotiate this percentage, especially as your years of experience grow. Even more importantly, be sure that your contract indicates what services and products are included in your production and which are excluded.
Possible Salary
Other Income Including Spouse's/Partner's
The average salary for new veterinary graduates is about $68K. Can you produce enough revenue for your employer to pay the salary you need? Don't forget to include your spouse's or significant other's income here so it flows through to total household income on future pages.
VPINW_Logo
Household Income
1
1
1
1
1
    Student Loan Calculator  
Help                  
Traditional Loans
Loan 1 Loan 2 Loan 3 Loan 4
11111 Input Data Amount Borrowed:
Annual Interest Rate
Number of Years
Output Data Monthly Payment:
VPINW_Logo
Total Amount Paid:
Total Interest Paid:
IBR Monthly Payment click here to calculate
© 2005, Practice in Practice Management Case Studies, All rights reserved.
      Credit Card Calculator      
Help            
               
1111 11111 Input Data
Balance:
Annual Interest Rate
Planned Monthly Payment
VPINW_Logo
Output Data Minimum Monthly Payment Allowed
Years to Zero Balance
Total Amount Paid:
Total Interest Paid:
© 2010, Practice in Practice Management Case Studies, All rights reserved.
    Auto Loan Calculator  
Help            
        Lease vs. Buy      
Input Data
Price of Car
Downpayment
Annual Depreciation Rate
Residual Value
Amount Financed
Annual Interest Rate
Money Factor (Ask Dealer) N.A.
Number of Years
Number of cars to lease or buy?
1111 Output Data Depreciation Cost: N.A.
Lease Cost: N.A.
Total Monthly Payment:
Total Amount Paid:
Equity in Car at Termination $0
Total Cost of Deal:
VPINW_Logo
True Monthly Cost:
© 2010, Practice in Practice Management Case Studies, All rights reserved.        
    Home Expenses Calculator    
Help
Input Data
Cost of Home
Downpayment
Annual Interest Rate
Number of Years
1111 11111 Output Data Monthly Payment:
Est. Property Taxes (1%)
Insurance
Maintenance
Total Monthly Costs
VPINW_Logo       Total Amount Paid:    
Total Interest Paid:
Tax Benefits per year
Purchase Home?
y n
© 2010, Practice in Practice Management Case Studies, All rights reserved.
      Retirement Savings Calculator    
Help
Input Data
Current Age
Retirement Age
Expected Annual Household Income (from salary worksheet)
Expected Rate of Return before Retirement
Expected Rate of Return during Retirement
Expected salary increase per year (%)
Retirement Income as Percent of Working Income
Annual Social Security Benefits after Retirement (estimate) Social Security Calculator
Value of Current Retirement Savings
Output Data Salary at Retirement (in future dollars)
Retirement Income Needed per Year
Social Security Receipts
Retirement Income Unmet
VPINW_Logo
Savings Needed at Retirement (in future dollars)
Future Value of Current Retirement Savings
Amount you still need to save
Amount to save per month
© 2010, Practice in Practice Management Case Studies, All rights reserved.
Personal Savings Calculator
Help            
1111 1111 ##### Input Data
Interest Rate
Number of Years
Amount Saved per Month
VPINW_Logo
Output Data Amount Saved
Interest Received
© 2010, Practice in Practice Management Case Studies, All rights reserved.
 
Estimated Annual Expenses
Help
Monthly Annual
1111111 Debt/Loans
College Loans1
Loan 1
Loan 2
Loan 3
Loan 4
IBR
Total College Loans
Car Payment2
Credit Cards3
Housing
Homeowners
Mortgage4
Property Taxes4
Insurance4
Home Repairs & Maint.4
Renters
Rent
Maint. & Supplies
Renters Insurance Premium
Utilities
Monthly Base Telecomm
Long Distance/Cell
Cable/Satellite TV
Gas/Electricity
Water/Garbage/Sewage
Automobile
Gas
Insurance
Repairs and Maintenance
License/Registration
Mass Transit
Food
Groceries
Meals out
Child Care
Daycare/Nanny
Private Education Tuition
Childrens Clothing
Diapers
Other
Insurance
Health
Life
Disability Ins (click for quote)
Prof Lblty (if unpaid by employer)
Uninsured Medical Expenses
Medical & Copays
Dental (annual exam & prophy)
Optometrist/Contact Lenses
Prescription/OTC Drugs
Pet Insurance (click for quote)
Other
Entertainment Movies/Dining/TGIF
Clothes Dress like a doctor!
Miscellaneous
Job Search Expenses
Pet Food
Pet Care (inc Med Costs)
Personal Hygiene/Hair/Cosmetics
Books, Newspapers, Magazines
Vet Cont Education
Gifts/Flowers
Charitable Contributions
Travel to Visit Family
Vacation
Cleaning and Laundry
Other Tuition
Text Books
Expenses I may have forgotten
Total Expenses
Contributions to Savings
Retirement5
Other6
Total Fixed and Variable Household Expenses
Household Income5:
Adjusted Gross Income:
Marital Status for Tax Purposes
S=Single, M=Married
Children for Tax Purposes
Total Exemptions
Deductions
Taxable Income
State Taxes (click for info)
Federal
FICA/Medicare (7.65% of Gross)
Federal Income Tax
Total Taxes
Net Income (gross wages less taxes)
Monthly Annually
Personal Profit      
Note:
1. From Student Loans Worksheet
4. From Home Expenses Worksheet
2. From Auto Lease vs. Buy Worksheet
5. From Salary Worksheet
3. From Credit Cards Worksheet
6. From Personal Savings Worksheet
VPINW_Logo
© 2010, Practice in Practice Management Case Studies, All rights reserved.
Expense Analysis
Help      
Classification of Expenses and Recommendations  
Your Budget
Expenses Dollars % of Income Recommended
Housing 25-35%
Utilities 5-10%
Transportation 10-15%
Food 5-15%
Savings,Insurance, Health Care 5-10%
Personal Expenses 5-10%
Student Loans <15%
Health/Medical 5-10%
Recreation 5-10%
Credit <5%
Taxes <32%
Total 100%
Analysis of Debt  Your Debt     
Student Loans
Auto Loans/Lease
Credit
Total
 Your Budget   Recommended 
Debt/Income Ratio  <36.0% 
Analysis of Housing Expenses    
Mortgage
Property Taxes
Homeowners Insurance
Total
Housing Expense Ratio  <28% 
VPINW_Logo
 
© 2010, Practice in Practice Management Case Studies, All rights reserved.
2014 Tax Schedule:
    Standard Deduction:        
Adj Gross Income
Number of Exemptions
AGI
Taxable Income
Deduction for Exemptions
Your situation: Taxable Income Tax Plus Of the amount over Equals   Standard Deduction        
             
Single Schedule
Taxable income is over But not over The tax is Plus Of the amount over     Standard Deductions - 2014        
 $                -    $         9,075  $           -   10%
Personal Exemption 3950
 $           9,075  $       36,900  $         908 15%
Single Standard 6200
 $          36,900  $       89,350  $      5,081 25%
Married 12400
 $          89,350  $     186,350  $     18,194 28%
 $        186,350  $     405,100  $     45,354 33%
 $        405,100  $     406,750  $   117,541 35%
 $        406,750
 $   118,119 40%
Married Filing Jointly
Taxable income is over But not over The tax is Plus Of the amount over                
 $                -    $       18,150  $           -   10%
 $          18,150  $       73,800  $      1,815 15%
 $          73,800  $     148,850  $     10,163 25%
 $        148,850  $     226,850  $     28,925 28%
 $        226,850  $     405,100  $     50,765 33%
 $        405,100  $     457,600  $   109,588 35%
 $        457,600
 $   127,963 40%
Taxable income is over But not over The tax is Plus Of the amount over                
 $                -    $           -   10%  $             -  
 $           9,075  $         908 15%  $        9,075
 $          36,900  $      5,081 25%  $      36,900
 $          89,350  $     18,194 28%  $      89,350
 $        186,350  $     45,354 33%  $     186,350
 $        405,100  $   117,541 35%  $     405,100
 $        406,750  $   118,119 40%  $     406,750