Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Theory And Policy

Authors: Steven Michael Suranovic

1st Edition

193612646X, 9781936126460

More Books

Students also viewed these Finance questions