Scribd
Upload
554 views2 pages

Stefanek Family Budget: Author Date Purpose

The document provides an overview of the monthly budget for Edmund and Lydia Stefanek for the year. It shows that their monthly mortgage payment is $1,551.94 at 4.3% annual interest over 25 years. It also includes a table showing their monthly income, expenses, and net income for each month of the year. On average, their monthly income is $6,350 while their expenses are $4,689, leaving an average monthly net income of $1,661. The largest expenses are their mortgage at 33% of costs, followed by miscellaneous at 21% and food at 13%.

Uploaded by

salini sasi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
554 views2 pages

Stefanek Family Budget: Author Date Purpose

The document provides an overview of the monthly budget for Edmund and Lydia Stefanek for the year. It shows that their monthly mortgage payment is $1,551.94 at 4.3% annual interest over 25 years. It also includes a table showing their monthly income, expenses, and net income for each month of the year. On average, their monthly income is $6,350 while their expenses are $4,689, leaving an average monthly net income of $1,661. The largest expenses are their mortgage at 33% of costs, followed by miscellaneous at 21% and food at 13%.

Uploaded by

salini sasi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

04/17/2020

Stefanek Family Budget


Author Salini Sasi
Date Friday, 17 April, 2020
Purpose To provide an overview of the monthly
budget of Edmund and Lydia Stefanek

470627853.xlsx Page 1 Documentation


Stefanek Family Budget
Mortage $ 285,000
Annual Interest Rate 4.30%
Interest Rate per Month 0.36%

Years 25
Total Payments 300

Monthly Payment $ (1,551.94)

Income & Expenses Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Edmund 4,750 4,750 4,750 4,750 4,750 4,750 4,750 4,750 4,750 4,750 4,750 4,750
Income Lydia 1,500 1,200 1,500 1,400 1,100 2,300 2,200 2,400 1,500 1,300 1,300 1,500
Total Income 6,250 5,950 6,250 6,150 5,850 7,050 6,950 7,150 6,250 6,050 6,050 6,250
Food -480 -430 -575 -615 -545 -675 -725 -815 -575 -605 -625 -715
Utilities -135 -115 -145 -125 -130 -135 -155 -160 -125 -135 -105 -125
Phone -85 -85 -105 -125 -110 -120 -115 -135 -85 -85 -125 -135
Insurance -410 -410 -410 -475 -475 -525 -525 -525 -525 -575 -575 -575
Expenses Car -325 -325 -325 -325 -325 -325 -325 -325 -325 -325 -325 -325
Travel -105 -55 -135 -275 -1,100 -225 -235 -1,750 -75 -125 -715 -725
Mortgage -1,552 -1,552 -1,552 -1,552 -1,552 -1,552 -1,552 -1,552 -1,552 -1,552 -1,552 -1,552
Misc. -400 -350 -300 -375 -5,750 -275 -180 -2,420 -210 -375 -415 -895
Total Expenses -3,492 -3,322 -3,547 -3,867 -9,987 -3,832 -3,812 -7,682 -3,472 -3,777 -4,437 -5,047
NET Net Income 2,758 2,628 2,703 2,283 -4,137 3,218 3,138 -532 2,778 2,273 1,613 1,203

Monthly Average Trend


Edmund 4,750 Income Expenses
Income Lydia 1,600
Total Income 6,350 Food
Misc. 13% Food
Food -615 21% Utilities Utilities
Utilities -133 Phone
3%
2% Phone
Phone -109 25% Edmund Insurance
Insurance -500 Lydia Insurance Car
11% Travel
Expenses Car -325
Mortgage
Travel -460 Misc.
75% Car
Mortgage -1,552 7%
Misc. -995 Mortgage
33% Travel
Total Expenses (4,689) 10%
NET Net Income 1,661

470627853.xlsx Budget 04/17/2020

You might also like