304 Goal Seek and IF Statements In-Class Example

304 Goal Seek and IF Statements In-Class Example - A 8...

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

View Full Document Right Arrow Icon
Using an IF Statement determine which column has a larger # for each row. Column 1 Column 2 If Statement 2 5 Column 2 4 3 Column 1 6 6 Column 2 8 2 Column 1 10 3 Column 1 12 7 Column 1 14 15 Column 2 16 12 Column 1 18 19 Column 2
Background image of page 1

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

View Full DocumentRight Arrow Icon
Using an IF statement determine the wages payable. Overtime is paid after 8 hours and is paid at 1.5 * Wage. Date Staff Project Hours Wage Wages Payable 6/2/98 Spencer A 11 $10.00 $125.00 5/10/01 Spencer B 6 $10.00 $60.00 5/12/01 Garvey A 4 $9.00 $36.00 5/20/01 Garvey C 7 $9.00 $63.00 5/30/01 Spencer C 9 $10.00 $95.00 6/1/01 Merrill A 8 $10.50 $84.00 6/1/01 Clayton A 6 $11.00 $66.00 6/3/01 Merrill A 10 $10.50 $115.50 6/10/01 Garvey B 8 $9.00 $72.00 6/12/01 Garvey A 6 $9.00 $54.00 6/20/01 Clayton C 8 $11.00 $88.00 6/20/01 Spencer
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: A 8 $10.00 $80.00 6/30/01 Clayton B 3 $11.00 $33.00 7/3/01 Merrill A 8 $10.50 $84.00 Goal Seek PMT $645.69 NPER 60 PV RATE 10% FV $50,000.00 PMT $500.00 NPER 73.04 PV RATE 10% FV $50,000.00 PMT $500.00 NPER 60 PV 6856.75 RATE 10% FV $50,000.00 PMT $500.00 NPER 60 PV RATE 19% FV $50,000.00 What would your PMT need to be to have FV of $50,000 with all else equal? What would your NPER need to be to have FV of $50,000 with all else equal? What would your PV need to be to have FV of $50,000 with all else equal? What would your RATE need to be to have FV of $50,000 with all else equal?...
View Full Document

This note was uploaded on 04/12/2011 for the course FIN 304 taught by Professor Doug during the Spring '11 term at Boise State.

Page1 / 3

304 Goal Seek and IF Statements In-Class Example - A 8...

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

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