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

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

View Full Document Right Arrow Icon
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."
Background image of page 1

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

View Full DocumentRight Arrow Icon
k"
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
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%)
Background image of page 5

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

View Full DocumentRight Arrow Icon
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.
Background image of page 6
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
Background image of page 7

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

View Full DocumentRight Arrow Icon
D8:D11,E8:E11) 2,2)
Background image of page 8
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
Background image of page 9

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

View Full DocumentRight Arrow Icon
D8:D11,E8:E11) 3)/D12,2)
Background image of page 10
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%)
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
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 Right Arrow Icon
Ask a homework question - tutors are online