Question

The data for Rhodes Corporation's has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer or $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to one decimal place. $ million b. What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place. 2018 s million 2017 s million c. What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place. 2018 S m illion 2017 s million d. What is the free cash flow far 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, nat 1,200,000. Do nat round intermediate calculations. Round your answer to one decimal place. million e. What is the ROIC for 2018? Round your answer to one decimal places. F. How much of the FCF did Rhodes use for each of the following purposes: after-tax interest, net debt repayments, dividends, net stock repurchases, and net purchases of short-term investments? (Hint: Remember that a net use can be negative.) Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round Intermediate calculations. Round your answers to one decimal place. million After-tax interest payment Reduction (increase) in debt Payment of dividends Repurchase (Issue) stock Purchase (Sale) of short-term investments million million million million

I am sorry I put the wrong picture now should be okay.

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

THERE IS A ROUNDING ERROR BECAUSE BALANCE SHEET TOTAL HAS SAME ROUNDING ERROR OF 0.1 MILLION. CHECK TOTAL EQUITY OF 2018

OTHERWISE EVERYTHING IS DONE PERFECTLY. IF WE TAKE ROUNDING TO 2 DIGITS, IT WILL TALLY EXACTLY

V E ENG 18 01 2020 54 B C D E F G H I J K L M 55 56 NOPAT [2018] 1096.9 FORMULAS (=B26*(1-B15) [=1828.1*(1-0.4) 1845.0 1590.0 (=(B35+B37+B38)-(B44+B45)] (=(C35+C37+C38)-(C44+C45)] [(112.5+1080+1897.5)-(750+ 495)] [(90+900+1650) -(600+450)] 58 NOWC [2018] 59 NOWC [2017] 60 61 TOTAL NET OPERATING CAPITAL [2018] 62 TOTAL NET OPERATING CAPITAL [2017] 63 64 FREE CASH FLOW [2018] 3813.8 3165.0 (=B58 +B40] (=B59 +C40] 448.1 (=B56-(B61-B62)] 66 ROIC [2018] 28.8% (=B56/B61] (=193.5*(1-0.4)] [(180-150) +(1800-1500)] 68 USES OF FREE CASH FLOW 69 AFTER TAX INTEREST PAYMENT 70 REDUCTION (INCREASE) IN DEBT 71 PAYMENT OF DIVIDENDS 72 REPURCHASE(ISSUE) STOCK 73 PURCHASE (SALE) OF SHORT TERM INVESTMENTS 74 TOTAL 116.1 -330 882.7 -228.1 7.5 448.2 [B27*(1-B15)] (=(B46-C46) +(B48-C48)] (=B31] (=C50-B50] (=B36-C36] (=SUM(B69:B73)] [=1635.5-1407.4] [=45-37.5] 76 77 There is a rounding error because if check: balance sheet, liabilities side total has exact error of 0.1 million 78 so we are getting that rounding error 79 check total common equity total, it has error of 0.1 million 80 81 82 ... Sheels Sheel6 SMOLIRA Sheel sumproduct CONGRESS balance sheel increase decrease RHODES +