Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Suppose that you are given the following data for Niles Company : Note: The data and calculations are based on a 3 6 5 day

Suppose that you are given the following data for Niles Company :
Note: The data and calculations are based on a 365day year.
Cash and equivalents $337,500
Fixed assets $975,000
Sales $3,750,000
Net income $168,750
Current liabilities $360,000
Current ratio 2.5
DSO 18.25
ROE 12%
The current ratio is equal to ____. Plugging in the relevant values for the current ratio and current liabilities, and then solving yields a current assets value of ___. Adding fixed assets to current assets yields a value of total assets of ___
The days sales outstanding (DSO) ratio is equal to ___. Plugging in the relevant values for the DSO ratio and sales, and then solving yields an accounts receivable balance of _____.Return on equity (ROE) is to ____. Plugging in the relevant values for ROE and net income yields a value of total common equity of approximately ____.Recall that Total Assets=Total Liabilities and Equity. Mathematically, total liabilities and equity is equal to____. Plugging in the relevant values for total liabilities and equity, current liabilities, and equity (calculated using the previous identify) and then solving for long-term debt, yields a long-term debt of ____.
Return on assets (ROA) is equal to the product of profit margin multiplied by total assets turnover, which is equivalent to ______. Plugging in the relevant values for net income and total assets yields an ROA of approximately _____. Recall the following identity: Current Assets=Cash and equivalents+Accounts Receivable+Inventories. The quick ratio is equal to ______. Plugging in the relevant values for current assets, current liabilities, and inventories (calculated using the previous identity) yields a quick ratio of approximately _____.Suppose that Niles could reduce its DSO from 18.25 to 12.
Given the formula for DSO from the video, as well as the same annual sales of $3,750,000, the new value accounts receivable (associated with the new DSO) must be _____, all else equal. The change (or the absolute value of the difference between the original and new values) in accounts receivable represents an amount of approximately _____ in cash generated. As a result of the stock buy back, the ROA and ROE both ______.Suppose Niles uses the cash generated by the lower DSO to buy back common stock at book value, thus reducing common equity. As a result of this new, lower, DSO, total debt _______ and total capital ____. This means that the total debt/total capital ratio must ______.
Suppose that the following data is given for Niles Company
Cash and Equivalents: $787,500
Fixed Assets: $2,275,000
Sales: $8,750,000
Net Income: $393,750
Current Liabilities: $840,000
Current Ratio: 2.5
DSO: 18.25
ROE: 12%
Accounts Receivable would be _____
Current Assets ________
Total Assets ______
ROA _______
Common Equity _______
Quick Ratio ______
Long Term Debt ______
Suppose that niles could reduce it's DSO from 18.25 to 12 and use the cash that was generated to buy back common stock at book value would the following options Increase, Decrease or stay the Same:
Accounts Receivable _______
ROA _________
ROE _________
Total Debt/Total Capital Ratio ________

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Contemporary Business Mathematics with Canadian Applications

Authors: S. A. Hummelbrunner, Kelly Halliday, K. Suzanne Coombs

10th edition

978-0133052312

Students also viewed these Finance questions