Thursday, April 22, 2010

Blog #59

Fre Write

1st Block: Create a spreadsheet in Excel (using the Function Worksheet Payment Scenario from yesterday as a guide) that will calculate the payment of the house you picked out online yesterday. Interest Rate is 7.5% (Divide the .075 by 12 since you'll be making 12 monthly payments). The loan will be for 30 years (remember to multiply by 12 for the # of months since you'll pay a payment every month). The principal is the amount the house is selling for. The spreadsheet should have: Merged & Centered Title, Shading, Picture of House, Interest Rate, Term (or period), Principal, & Payment Amount (calculated from PMT function).

3rd & 4th Blocks: Continue working on your Dream Vacation Presentation. I'm hoping for the presentations to start next Wednesday. Remember, we're out Friday, so that gives us 2 days to present all the projects. If you're planning to bring food for extra points, please choose today and let me know tomorrow so I can approve the item.

No comments:

Post a Comment