Chapter04CorradoJordanRex - Chapter 4 Problems 1-21 Input...

This preview shows pages 1–12. Sign up to view the full content.

Chapter 4 Problems 1-21 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."

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

View Full Document
k"
Chapter 4 Question 1 Net Asset Value Input Area: Current assets \$3,500,000,000 Shares outstanding 110,000,000 Output Area: NAV \$31.82 =D7/D8 NAV = Asset / N

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

View Full Document
Chapter 4 Question 2 Front-end Loads Input Area: Current assets \$3,500,000,000 Shares outstanding 110,000,000 NAV \$31.82 Market price \$33.67 Output Area: Load fund? Yes =IF(D10>D9,"Yes","No") Front-end Load 5.50% =(D10-D9)/D10 P = V + L L% = L/P L% = (P-V)/P
Chapter 4 Question 3 Net Asset Value Input Area: Market price \$40.30 NAV = P + L Front-end load 2.00% Shares outstanding 12,500,000 Output Area: NAV \$39.49 =ROUND(D7*(1-D8),2) Market value of assets \$493,625,000 =D15*D9 P = V + L L% = L/P V = P(1-L%)

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

View Full Document
Chapter 4 Question 4 Money Market Fund. Input Area: NAV \$1.00 Fund appreciation 4.3% Investment \$25,000 Output Area: Initial shares 25,000 Final shares 26,075 =D15*(1+D8) Final NAV \$1.00 Because this is a money market fund.
Chapter 4 Question 5 Net Asset Value Input Area: Open-end fund Shares Stock price Stock A 3,000 \$42 Stock B 8,000 \$27 Stock C 5,500 \$38 Stock D 9,200 \$35 Mutual fund 50,000 Output Area: Total fund assets \$873,000.00 =SUMPRODUCT(D NAV \$17.46 =ROUND(E18/D12

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

View Full Document
D8:D11,E8:E11) 2,2)
Chapter 4 Question 6 Net Asset Value Input Area: Shares Stock price Stock A 3,000 \$42 Stock B 8,000 \$27 Stock C 5,500 \$38 Stock D 9,200 \$35 Mutual fund 50,000 Liabilities \$75,000 Output Area: Total fund assets \$873,000.00 =SUMPRODUCT(D NAV \$15.96 =ROUND((E19-D13

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

View Full Document
D8:D11,E8:E11) 3)/D12,2)
Chapter 4 Question 7 Front-end Loads Input Area: Front-end load 5.00% NAV \$15.96 Output Area: Offering price \$16.80 =D8/(1-D7) L% = L/P P = V + L P = V/(1-L%)

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/17/2011 for the course FINANCE 1001 taught by Professor Lochengshu during the Spring '11 term at National Cheng Kung University.

Page1 / 40

Chapter04CorradoJordanRex - Chapter 4 Problems 1-21 Input...

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

View Full Document
Ask a homework question - tutors are online