ExcelProjectGroup15(1) - CISM-02P Busn Apps 2:00-3:15pm T...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CISM-02P Busn Apps 2:00-3:15pm T Jenna Sicard Timov Family Budget Author Jenna Sicard Date 2/7/2012 Purpose To evaluate two mortgage proposals based on projected income and expenses CISM-02P Busn Apps 2:00-3:15pm T Jenna Sicard Timov Family Budget Mortgage Plan 1 Annual Rate 6.70% Choose a Mortgage Plan (1 or 2) 2 Compounded per Yr. 12 0.56% Monthly Years 30 Year-End Summary Yearly Average Maximum Minimum 360 Income Sergei 60,000 5,000 5,000 5,000 $395,000.00 Ava 43,500 3,625 5,200 1,100 $2,548.85 Total 103,500 8,625 10,200 6,100 Expenses Taxes 30,700 2,558 2,900 1,900 Mortgage Plan 2 Annual Rate 6.70% Car Payments 3,660 305 305 305 Compounded per Yr. 12 Health Insurance 7,620 635 635 635 0.56% Other 21,200 1,767 5,800 800 Years 20 Mortgage 27,266 2,272 2,272 2,272 240 Total 63,180 5,265 9,140 4,140 $300,000.00 Net Cash Flow 40,320 3,360 5,560 (1,140) $2,272.18 Monthly Values Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Income Sergei 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Ava 4,100 4,500 4,800 5,200 3,300 2,700 1,100 3,000 3,300 3,800 4,000 3,700 Total $9,100.00 $9,500.00 $9,800.00 $10,200.00 $8,300.00 $7,700.00 $6,100.00 $8,000.00 $8,300.00 $8,800.00 $9,000.00 $8,700.00 Expenses Taxes 2,900 2,800 2,700 2,900 2,400 2,300 1,900 2,400 2,400 2,600 2,800 2,600 Car Payments 305 305 305 305 305 305 305 305 305 305 305 305 Health Insurance 635 635 635 635 635 635 635 635 635 635 635 635 Other 4,900 950 950 800 900 900 1,700 5,800 800 900 1,200 1,400 Mortgage 2,272 2,272 2,272 2,272 2,272 2,272 2,272 2,272 2,272 2,272 2,272 2,272 Total $8,740.00 $4,690.00 $4,590.00 $4,640.00 $4,240.00 $4,140.00 $4,540.00 $9,140.00 $4,140.00 $4,440.00 $4,940.00 $4,940.00 Net Cash Flow $360.00 $4,810.00 $5,210.00 $5,560.00 $4,060.00 $3,560.00 $1,560.00 $(1,140.00) $4,160.00 $4,360.00 $4,060.00 $3,760.00 Monthly Rate (Rate) Total Months (Nper) Principal (PV) Payment (PMT) Monthly Rate (Rate) Total Months (Nper) Principal (PV) Payment (PMT) CISM-02P Busn Apps 2:00-3:15pm T Jenna Sicard 2,900 2,800 2,700 2,900 2,400 2,300 1,900 2,400 2,400 2,600 2,800 2,600 Second Mortgage Total Expenses 1 2 3 4 5 6 7 8 9 10 11 12 CISM-02P Busn Apps 2:00-3:15pm T Jenna Sicard Emp ID Last Name Hire Date Birth Date Sex Location Awards Plan 7/1/2013 1024Hovey 8/28/2011 9/6/1966M Austin FT Y 3S $85,000 HMOF ### 18000 #NAME? HMOF $1,500 Bonus Pay Grade 1 $2,500 1025 Overton 5/24/2007 2/15/1986F Home FT N 2S $40,000 HMOF ### 18000 #NAME? HMOI $875 Bonus Pay Grade 2 $5,000 1026Fetherston 4/24/2012 9/24/1968 M New Orleans FT Y 2S $37,244 HMOF ### 18000 #NAME? PPOF $1,650 Bonus Pay Grade 3 $7,500 1027Lebrun 7/18/2011 8/9/1959F Austin FT N 3S $80,000 None ### 10500 #NAME? PPOI $950 1028 Hanson 8/21/2012 7/15/1950M Austin FT Y 3S $65,000 None ### 10500 #NAME? None $- 1029Philo 3/5/2012 5/2/1958 M New Orleans FT Y 3S $125,000 PPOI ### 11400 #NAME?...
View Full Document

Page1 / 5

ExcelProjectGroup15(1) - CISM-02P Busn Apps 2:00-3:15pm T...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online