06 Jul $71,674.0Book Value of Equity Invested From Balance Sheet E
$71,674.0Book Value of Equity Invested From Balance Sheet End of Previous Full Year$78,228.0Book Value of Equity Invested Currently (May be Same as Above)$8,354.0Annual Net Income from Previous Year10.0%Dividend Payout Ratio1.20Beta of Company’s Stock3.50%Risk-free Rate5.00%Equity (Market) Excess Return Premium9.50%Cost of Equity (Computer Calculates)11.66%Return on Equity (Computer Calculates)517.735Number of Shares Outstanding3.00%Assumed Growth Rate for Net Income After Year 59.50%Assumed Return on Equity After Year 59.50%Assumed Cost of Equity After Year 5Year123456Net Income$9,117.9$10,074.4$11,131.2$12,298.8$13,589.0- Equity Cost$7,431.7$8,211.2$9,072.6$10,024.3$11,075.9Excess Equity Return$1,686.24$1,863.13$2,058.57$2,274.52$2,513.12Present Value$1,539.9$1,553.9$1,567.9$1,582.1$1,596.4Beginning Book Value of Equity78,228.086,434.195,501.0105,519.1116,588.1Cost of Equity9.50%9.50%9.50%9.50%9.50%Equity Cost$7,431.7$8,211.2$9,072.6$10,024.3$11,075.9Return on Equity11.66%11.66%11.66%11.66%11.66%Net Income$9,117.9$10,074.4$11,131.2$12,298.8$13,589.0Dividend Payout Ratio10.0%10.0%10.0%10.0%10.0%Dividends Paid$911.8$1,007.4$1,113.1$1,229.9$1,358.9Retained Earnings$8,206.1$9,066.9$10,018.1$11,069.0$12,230.1$12,597.0Terminal Value of Excess Returns$0.0The PV of Excess ReturnsValuationWill Equal 0 if the Assumed ROEBook Value of Equity Invested Currently$78,228.0= or < the Assumed Cost of EquityPresent Value of Excess Return (Next 5 Years)$7,840.2Present Value of Terminal Value of Excess Returns$0.0Value of Equity$86,068.2Number of Shares517.735Value per Share$166.24
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.