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 following question using excel Please answer the question using

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!