chapter 19 & 20
goodjob
2014-06-15_233353_6.5.xlsxChapter 20
| Chapter 20 | |||
| Problem 6 | |||
| Input boxes in tan | |||
| Output boxes in yellow | |||
| Given data in blue | |||
| Calculations in red | |||
| Answers in green | |||
| NOTE: Some functions used in these spreadsheets may require that | |||
| the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. | |||
| To install these, click on "Tools|Add-Ins" and select "Analysis ToolPak" | |||
| and "Solver Add-In." | |||
#6
| Chapter 20 | |||
| Question 6 | |||
| Input Area: | |||
| Funds needed | $ 45,000,000 | ||
| Offer price | $ 31 | ||
| Spread | 7% | ||
| Administrative expense | $ 1,900,000 | ||
| Output Area: | |||
| Proceeds from sale | |||
| Number of shares offered | |||
