10 excel question

HIGHLIGHT ANSWERS IN YELLOW

follow FORMAT IN YOUTUBE VIdeo ---- >https://www.youtube.com/watch?v=ENYZcqHGYIE

19.7 Addition to retained earnings: Northwood, Inc., has revenue of $455,316 and cos taxes at a rate of 31 percent. If the firm pays out 45 percent of its earnings as divide much earnings are retained and what is the firm's retention ratio? evenue of $455,316 and costs of $316,487 and pays cent of its earnings as dividends every year, how tion ratio? 19.8 Payout and retention ratio: Goodwin Corp. has revenues of $12,112,659, costs of payment of $412,375, and a tax rate of 34 percent. It paid dividends of $1,025,000 Find the firm's dividend payout ratio and retention ratio. s of $12,112,659, costs of $9,080,545, interest dividends of $1,025,000 to its stockholders. 19.9 Percent of sales: Cattail Corporation's financial statements for the fiscal year just ended are shown below: Cattail Corporation Financial Statements for the Fiscal Year Just Ended ($ thousands) Income Statement Net Sales $ 1,500 Costs 350 Net Income $ 1,150 Assets Total Balance Sheet $ 700 Debt Equity $ 700 Total Cattail management expects sales to increase by 14 percent next year. Assume that the financial statement accounts vary directly with changes in sales and tha management has no financing plan at this time. Given this information, develop a pro forma income statement for Cattail for the next fiscal year. nts for the fiscal year e Sheet $ $ 600 ## 700 ent next year. Assume anges in sales and that is information, develop al year. 19.10 Percent of sales: Given the data for Cattail Corporation in Problem 19.9, if you balance sheet items also vary with the change in sales, develop a pro forma ba for the next fiscal year. Assuming that the firm did not sell or repurchase stock, cash dividend implied by the pro forma income statement and balance sheet? 19.9 Percent of sales: Cattail Corporation's financial statements for the fiscal year ju Cattail Corporation Financial Statements for the Fiscal Year Just Ende Income Statement Net Sales $ 1,500,000 Costs ### Net Income $ 1,150,000 Assets Total Cattail management expects sales to increase by 14 percent next year. Assum changes in sales and that management has no financing plan at this time. Give for Cattail for the next fiscal year. on in Problem 19.9, if you assume that all s, develop a pro forma balance sheet for Cattail sell or repurchase stock, what is the ent and balance sheet? ments for the fiscal year just ended are shown below: Corporation the Fiscal Year Just Ended Balance Sheet $ 700,000 $ 700,000 Debt Equity Total $ $ 600,000 ### 700,000 percent next year. Assume that the financial statement accounts vary directly with ng plan at this time. Given this information, develop a pro forma income statement 19.12 Capital intensity ratio: Tantrix Confectioners has total assets of $3,257,845 and sales of $5,123,951. What is the firm's capital intensity ratio? of $3,257,845 and 19.13 Capital intensity ratio: McDonald Metal Works has been able to generate sales of $13,445,196 on assets of $9,145,633. What is the firm's capital intensity ratio? been able to generate sales of m's capital intensity ratio? 19.14 Capital intensity ratio: For McDonald Metal Works in Problem 19.13, how much m sales grow if the capital intensity ratio has to drop to 60 percent? Indicate your answ both percent of sales and dollar sales increase. m 19.13, how much must nt? Indicate your answer in 19.15 Internal growth rate: Swan Supply Company has net income of $1,212,335, asset retains 70 percent of its income every year. What is the company's internal growth r e of $1,212,335, assets of $12,522,788 and pany's internal growth rate? 19.16 Sustainable growth rate: If Newell Corp. has a ROE of 13.7 percent and a dividend payout ratio of 32 percent, what is its sustainable growth rate? of 13.7 percent and a able growth rate? 19.17 EFN and growth: Refer to Exhibits 19.10 and 19.11 in the text. The EFNs for sever growth rates for Empire Enterprises are as follows: Growth Rate(%) 0% 5 9.6 10 15 20 EFN($) (4.80) (2.30) 0.20 2.70 5.20 As a drill, you may want to check the calculations and plot the line to replicate the graph in Exhibit 19.11. he text. The EFNs for several ot the line to replicate the