Question: Please answer the following question using excel Please answer the question using excel Case 3 (10pts) LO-2: calculate Time Value of Money, Financial Ratios and
Please answer the following question using excel

Please answer the question using excel
Case 3 (10pts) LO-2: calculate Time Value of Money, Financial Ratios and Cash Flow PT. Moses has total assets as of the end in January 2020, Current Asset Rp 80,000,000. and Non- Current Asset is Rp 120,000,000. During the month has total sales Rp 50,000,000, Net Income After Tax is Rp 20,000,000. Total Short Term Debt is Rp 50,000,000, Bond Payable (long term) is 50,000,000 and Total Equity is Rp 100,000,000.- The dividend will be distributed at 20% of Net Income. Calculate: a. Net Profit Margin, Return on Assets and Return on Equity b. Total Debt to Equity C. Business Retention Rate (please find yourself from internet and provide reference hint 100%- dividen) d. Sustainable Growth Rate (please find yourself from internet and provide reference - hint: ROEX BRR)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
