AutoSave Off F410 Sample Excel Quiz 1 Questions - Compatibility Mode - Word O Search Brooke McNeilly BM 0 X File Home Insert Design Layout References Mailings Review View Help Share Comments X LA Times New Rom 12 AA Aa to E ALT AaBbCel AaBbCI AaBbCc AaBbc AaBbCcD 1 Heading 1 1 Normal Title Subtitle Find Sc Replace hos Select Paste E BI U Bb x, x? ADA IE 1 No Spac... Dictate Sensitivity Editor Clipboard Font Paragraph Styles Editing Voice Sensitivity Editor Problems in Business Finance 382, Test 1, Q12., Fall 2009 Q2a. Your old college roommate, Dennis Haydell (F382, Fa'09) is trying to get his start- up business off the ground and is looking for investment capital. If you lend him $35,000 today he has promised to make semi-annual repayments of $7,456.57 over three years. Make the appropriate calculation to determine if you should accept this investment if you require a 15% return on this investment. Should you accept this investment? Why? Note: There are three approaches (Q2a., Q2b., and Q2c.) that can be used to answer this question. Provide all three solutions using the templates below. Place the appropriate values in the proper cells in rows 7, 11, and 15, given the columns as provided below. Note, where relevant, present value answers should be shown as a negative number. Circle the answer. Provide the EXACT Excel function that solves the problem in the space below using cell references throughout. You must use a PENCIL! B Row Number 5 6 7 Q2a. m Column Letter D E Write problem type here PV PMT FV #Yrs ARate EXACT EXCEL FUNCTION: 9 10 11 Q2b. m Write problem type here PMT FV #Yrs ARate PV EXACT EXCEL FUNCTION: Page 2 of 2 12 of 373 words Focus 100% AutoSave Off HI F410 Sample Excel Quiz 1 Questions - Compatibility Mode - Word Search Brooke McNeilly BM 0 File Home Insert Design Layout References Mailings Review View Help Share Comments Times New Rom - 12 A A Aar to Ever SE AL BIUab x2 ab X, X ADA Find Sc Replace hos Select AaBbCel AaBbCd AaBbCd AaBbc AabbCcD 1 Heading 1 1 Normal 1 No Spac... Title Subtitle Paste Dictate Sensitivity Editor y Clipboard F Font Paragraph Styles Editing Voice Sensitivity Editor " Note: There are three approaches (Q2a., Q2b., and Q2c.) that can be used to answer this question. Provide all three solutions using the templates below. Place the appropriate values in the proper cells in rows 7, 11, and 15, given the columns as provided below. Note, where relevant, present value answers should be shown as a negative number. Circle the answer. Provide the EXACT Excel function that solves the problem in the space below using cell references throughout. You must use a PENCIL! Column Letter D A B. Row Number 5 6 7 Q2a. E F Write problem type here PMT FV m #Yrs ARate PV EXACT EXCEL FUNCTION: 9 10 11 Q2b. m Write problem type here PMT #Yrs ARate PV FV EXACT EXCEL FUNCTION: 13 14 15 Q2c. m Write problem type here PMT FV #Yrs ARate PV EXACT EXCEL FUNCTION: Page 2 of 2 2 373 words DX Focus 1 + 100%