In case different Questions\/problems are asked by your instructor just email me\t\u00a0\tComplete\u00a0the following problem sets in\u00a0Financial Management\u00a0using\u00a0Microsoft\u00ae\u00a0Excel\u00ae:\t\t\tChapter 7 : 5, 15\t\t\tChapter 9 : 10\t\t\tChapter 11 : 12\t\t\tChapter 16: 9, 10\t\u00a0\t\u00a0\tChapter 7\t5. King Waterbeds has an annual cash dividend policy that raises the dividend each year\tby 4%. Last year’s dividend was $0.40 per share. What is the price of this stock if\ta. an investor wants a 5% return?\tb. an investor wants an 8% return?\tc. an investor wants a 10% return?\td. an investor wants a 13% return?\te. an investor wants a 20% return?\t\u00a0\t15. Using Yahoo! Finance (http:\/\/finance.yahoo.com\/) and ticker symbol PEP, find\tPepsiCo’s historical dividend payment and current price. Historical dividends are available in the historical price section. Use these payments to find the annual\tdividend growth rate. (If you have a quarterly pattern be sure to annualize this\tquarterly growth rate.) Now, find the required rate of return for this stock, assuming\tthat the future dividend growth rate will remain the same and the company has an\tinfinite horizon. Does this return seem reasonable for PepsiCo?\tChapter 9 “\ufffd Q10\t10. Net present value. Lepton Industries has four potential projects, all with an initial cost of $1,500,000. The capital budget for the year will allow Lepton to accept only one of the four projects. Given the discount rates and the future cash flows of each project, determine which project Lepton should accept.\tANSWER:\t\u00a0\tChapter 11 “\ufffd Q12\t12. Book value versus market value components. The CFO of DMI is trying to determine the company’s WACC. Brad, a promising MBA, says that the company should use book value to assign the components percentage for the WACC. Angela, a long-time employee and experienced financial analyst, says the company should use market value to assign the components. The after-tax cost of debt is at 7%, the cost of preferred stock is at 11%, and the cost of equity is at 14%. Calculate the WACC using both the book value and market value approaches with the following information. Which do you think is better? Why?\t\u00a0\tChapter 16\t9. Finding the WACC. Monica is the CFO of Cooking for Friends (CFF) and uses the pecking order hypothesis (POH) philosophy when she raises capital for company projects. Currently, she can borrow up to $600,000 from her bank at a rate of 8.5%, float a bond for $1,100,000 at a rate of 9.25%, or issue additional stock for $1,300,000 at a cost of 17%. What is the WACC for CFF if Monica chooses to invest: a. $1,000,000 in new projects? b. $2,000,000 in new projects? c. $3,000,000 in new projects?\t\u00a0\t10. Finding the WACC. Chandler has been hired by Cooking for Friends to raise capital for the company. Chandler increases the funding available from the bank to $900,000, but with a new rate of 8.75%. Using the data in Problem 9, determine what the new weighted average cost of capital is for borrowing $1,000,000, $2,000,000, or $3,000,000\tPrepare\u00a0the\u00a0DuPont analysis\u00a0for each of the two companies you researched in Week 2.\tDevelop\u00a0a 350-word analysis of the following:\t\t\tCompare the two company findings.\t\t\tAnalyze the research and calculations to determine in which company you would invest.\tFormat\u00a0the assignment consistent with APA guidelines.\tClick\u00a0the Assignment Files tab to submit your assignment.<\/p>\n","protected":false},"excerpt":{"rendered":"
In case different Questions\/problems are asked by your instructor just email me \u00a0 Complete\u00a0the following problem sets in\u00a0Financial Management\u00a0using\u00a0Microsoft\u00ae\u00a0Excel\u00ae: Chapter 7 : 5, 15 Chapter 9 : 10 Chapter 11 : 12 Chapter 16: 9, 10 \u00a0 \u00a0 Chapter 7 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-216681","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/216681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=216681"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/216681\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=216681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=216681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=216681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}