jagomart
digital resources
picture1_Spreadsheet For Expenses 41066 | Pharmbudgetplanner22


 179x       Filetype XLSX       File size 0.03 MB       Source: www.uh.edu


File: Spreadsheet For Expenses 41066 | Pharmbudgetplanner22
sheet 1 details how to use this document enter approximate budget values into the appropriate cells each area with recurring costs ie rent will be multiplied per the quot time ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Details
HOW TO USE THIS DOCUMENT



*Enter approximate budget values into the appropriate cells. Each area with recurring costs (i.e. rent) will be multiplied per the "time applicable".



*Each tab is for a designated school year and the typical fees associated with each. Expenses that apply to all students have been incorporated (but may change)



*The automatic totals will appear in the colored cells. The totals reflect the white cells under the colored category.



*If you add another row, make sure that it is included in the formula for the category total (shown in the colored cell above). Easiest way would be to right-click where you want to put an empty space > "insert" > shift cells down



*If you select a colored cell and then click the formula box (up at the top right above the A, B, C, … columns) it will show which cells are incorporated into the formula



*Time intervals can be adjusted as necessary to best reflect payment schedule



*Numerical values in parentheses indicate negative values



*This is a guide for planning a budget, not a strict financial accounting sheet



*There are several helpful budgeting apps/websites to look into (example: everydollar.com) for a more refined budget.













*Estimates shown based on previous years (full year total), all values are subject to change




Pharm 1 Pharm II Pharm III Pharm IV
Tuition/Fee calculator: https://www.uh.edu/financial/graduate/tuition-fees/index.php







Number of credit hours in a semester may vary between students depending on when they take elective courses



Resident $26,497.00


Non-resident $45,801.00







Organization Dues



Mandatory organizations




























Optional organizations




--



-- -- -- --






-- -- -- --














































































































Professional Meetings




Sheet 2: Pharm I
*Estimates shown based on previous years, all values are subject to change



EXPENSES $-
INCOME $-





Home Life $-
Loans (New, anticipated/accepted) $-
Months applicable (Lease term) 12
Federal $-
Rent $-
Private $-
Utilities $-


Parking $-


Additional fees $-
Scholarships $-
Phone $-


Internet $-


TV $-







Food $-
Savings (applied to education) $-
Weeks 52


Groceries (weekly) $-


Eating out (weekly) $-







Transportation $-
Assistance and Net Earnings (after taxes and witholding) $-
Installments (payments per year) 12
Student earnings $-
Gas $-
Spouse/Partner earnings $-
Bus fare $-
Parent assistance $-
Parking fees $-


Auto loan/lease payments $-





Other $-
Insurance $-


Installments (payments per year) 1


Medical $-


Dental $-


Vision $-


Auto $-
END OF YEAR BALANCE: $-
Home/Renter $-







Family (children, pets, etc.) $-


Months applicable 12


Care $-


Education $-


Other $-







Current Finances $-


Months applicable 12


Payments for existing credit card debt (per month) $-


Payment for existing loans (per month) $-







Education



Tuition and Fees - Fall $-


Tuition and Fees - Spring $-


Tuition and Fees - Summer




$-






































$-



$-

















Other/Misc. $-



$-



$-




























Sheet 3: Pharm II
*Estimates shown based on previous years, all values are subject to change




EXPENSES $-
INCOME $-






Home Life $-
Loans (New, anticipated/accepted) $-
Months applicable (Lease term) 12
Federal $-
Rent $-
Private $-
Utilities $-



Parking $-



Additional fees $-
Scholarships $-
Phone $-

$-
Internet $-

$-
TV $-









Food $-
Savings (applied to education) $-
Weeks 52

$-
Groceries (weekly) $-

$-
Eating out (weekly) $-









Transportation $-
Assistance and Net Earnings (after taxes and witholding) $-
Installments (payments per year) 12
Student earnings $-
Gas $-
Spouse/Partner earnings $-
Bus fare $-
Parent assistance $-
Parking fees $-



Auto loan/lease payments $-






Other $-
Insurance $-



Installments (payments per year) 1



Medical $-



Dental $-



Vision $-



Auto $-
END OF YEAR BALANCE: $-
Home/Renter $-








$-
Family (children, pets, etc.) $-



Months applicable 12



Care $-



Education $-



Other $-









Current Finances $-



Months applicable 12



Payments for existing credit card debt (per month) $-



Payment for existing loans (per month) $-









Education $-



Tuition and Fees - Summer $-



Tuition and Fees - Fall $-



Tuition and Fees - Spring $-











































































Other/Misc. $-




$-




$-


































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet details how to use this document enter approximate budget values into the appropriate cells each area with recurring costs ie rent will be multiplied per quot time applicable tab is for a designated school year and typical fees associated expenses that apply all students have been incorporated but may change automatic totals appear in colored reflect white under category if you add another row make sure it included formula total shown cell above easiest way would rightclick where want put an empty space gt insert shift down select then click box up at top right b c hellip columns show which are intervals can adjusted as necessary best payment schedule numerical parentheses indicate negative guide planning not strict financial accounting there several helpful budgeting appswebsites look example everydollarcom more refined estimates based on previous years full subject pharm ii iii iv tuitionfee calculator httpswwwuhedufinancialgraduatetuitionfeesindexphp number of credit hours sem...

no reviews yet
Please Login to review.