Looks good, but some of it is confusing me..not sure the formulas off to the right are, and some of the questions (i.e yield rate (six months)) are missing from your spreadsheet.
Can I ask you a quick question...In Part C on the worksheet the question is..
If the capital structure increases more than new common stock will have to be issuesed to finance new projects since internally generated RE runs out, and the required return on common stock will increase as demanded by shareholders.
Your response in the spreadsheet you sent gave me three things, do I need all three for the answer of this question. Or do I need to input all three in the answer and why?
Thank you again for the assistance!!!