jagomart
digital resources
picture1_Estimate Template Excel 41315 | Refund Estimation Calculator


 224x       Filetype XLSX       File size 0.02 MB       Source: studentaid.unc.edu


File: Estimate Template Excel 41315 | Refund Estimation Calculator
sheet 1 nc resident with family nc residentadjustment estimator disclaimer this tool is intended to help you calculate the possible refund you may have if you are moving offcampus with ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: NC Resident With Family
NC Resident-Adjustment Estimator
Disclaimer: This tool is intended to help you calculate the possible refund you may have if you are moving off-campus with family from on-campus housing. This is just an estimate and numbers are subject to change.

Updated Housing Plan: Living at home with family from on-campus
Max Aid Adjustment: 2039 (Your reduction in aid will depend on if you were awarded up to full need)


Refund Estimator:
Housing Calculation: Original billed housing charge (from bill):




Housing charge (from bill)/Number of days (109)= daily charge Daily charge: 0
Daily charge*Number of days in on-campus housing = New housing charge for fall 2020 Number of days:
Original housing charge-New housing charge= Potential refund of housing Total New Charge: 0

Estimated Housing Refund:



0

Meal Plan Calculation: Original meal plan charge (from bill):
Take number of days in which you were enrolled in meal plan prior to cancellation*Daily rate= New meal plan charge Daily charge (enter number of estimated days):




Take original mean plan charge - New plan charge = Potential estimated meal refund to use for meals at home









Weekly 21 0


Weekly 14 0
Approximate Daily Rates:



Weekly 6 0
Weekly 21: 20.70


Weekly 14: 17.66


Weekly 6: 11.31
Estimated Meal Plan Refund:


Weekly 21 0


Weekly 14 0


Weekly 6 0

*(choose the total that applies from above in your final calculation below)






Estimated Housing Refund (enter from above)


Estimated Meal Plan Refund (enter from above)*


Total estimated refunds: 0

Total estimated aid reduction: 2039

Potential refund from cashier's for living at home:



-2039

Sheet 2: NC Non-Resident With Family
NC Non-Resident-Adjustment Estimator
Disclaimer: This tool is intended to help you calculate the possible refund you may have if you are moving off-campus with family from on-campus housing. This is just an estimate and numbers are subject to change.

Updated Housing Plan: Living at home with family from on-campus
Max Aid Adjustment: 2757 (Your reduction in aid will depend on if you were awarded up to full need)


Refund Estimator:
Housing Calculation: Original billed housing charge (from bill):




Housing charge (from bill)/Number of days (109)= daily charge Daily charge: 0
Daily charge*Number of days in on-campus housing = New housing charge for fall 2020 Number of days:
Original housing charge-New housing charge= Potential refund of housing Total New Charge: 0

Estimated Housing Refund:



0

Meal Plan Calculation: Original meal plan charge (from bill):
Take number of days in which you were enrolled in meal plan prior to cancellation*Daily rate= New meal plan charge Daily charge (enter number of estimated days):




Take original mean plan charge - New plan charge = Potential estimated meal refund to use for meals at home









Weekly 21 0


Weekly 14 0
Approximate Daily Rates:



Weekly 6 0
Weekly 21: 20.70


Weekly 14: 17.66


Weekly 6: 11.31
Estimated Meal Plan Refund:


Weekly 21 0


Weekly 14 0


Weekly 6 0

*(choose the total that applies from above in your final calculation below)






Estimated Housing Refund (enter from above)


Estimated Meal Plan Refund (enter from above)*


Total estimated refunds: 0

Total estimated aid reduction: 2757

Potential refund from cashier's for living at home:



-2757

Sheet 3: NC Resident Off-Campus Ind.
NC Resident-Adjustment Estimator
Disclaimer: This tool is intended to help you calculate the possible refund you may have if you are moving off-campus independently from on-campus housing. This is just an estimate and numbers are subject to change.

Updated Housing Plan: Living off-campus independently
Max Aid Adjustment: 0 (Budget and aid will not change if you show proof of living off-campus)


Refund Estimator:
Housing Calculation: Original billed housing charge (from bill):




Housing charge (from bill)/Number of days (109)= daily charge Daily charge: 0
Daily charge*Number of days in on-campus housing = New housing charge for fall 2020 Number of days:
Original housing charge-New housing charge= Potential refund of housing Total New Charge: 0

Estimated Housing Refund:



0

Meal Plan Calculation: Original meal plan charge (from bill):
Take number of days in which you were enrolled in meal plan prior to cancellation*Daily rate= New meal plan charge Daily charge (enter number of estimated days):




Take original mean plan charge - New plan charge = Potential estimated meal refund to use for meals at home









Weekly 21 0


Weekly 14 0
Approximate Daily Rates:



Weekly 6 0
Weekly 21: 20.70


Weekly 14: 17.66


Weekly 6: 11.31
Estimated Meal Plan Refund:


Weekly 21 0


Weekly 14 0


Weekly 6 0

*(choose the total that applies from above in your final calculation below)






Estimated Housing Refund (enter from above)


Estimated Meal Plan Refund (enter from above)*


Total estimated refunds: 0





Potential refund from cashier's for moving off-campus independently:



0

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

...Sheet nc resident with family residentadjustment estimator disclaimer this tool is intended to help you calculate the possible refund may have if are moving offcampus from oncampus housing just an estimate and numbers subject change updated plan living at home max aid adjustment your reduction in will depend on were awarded up full need calculation original billed charge bill number of days daily new for fall chargenew potential total estimated meal take which enrolled prior cancellation rate enter mean use meals weekly approximate rates choose that applies above final below refunds cashier s nonresident nonresidentadjustment ind independently budget not show proof...

no reviews yet
Please Login to review.