Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started