Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE ANSWER IT IN EXCEL FORMAT Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to improve its cash

image text in transcribedPLEASE ANSWER IT IN EXCEL FORMAT

Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,395,000 (all on credit), and its net profit margin was 4%. Its inventory turnover was 5.0 times during the year, and its DSO was 43 days. Its annual cost of goods sold was $1,250,000. The firm had fixed assets totaling $355,000. Strickler's payables deferral period is 47 days. Assume a 365-day year. Do not round intermediate calculations. a. Calculate Strickler's cash conversion cycle. Do not round intermediate calculations. Round your answer to two decimal places. days b. Assuming Strickler holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. Do not round intermediate calculations. Round your answers to two decimal places. Total assets turnover: ROA: % c. Suppose Strickler's managers believe the annual inventory turnover can be raised to 8 times without affecting sale or profit margins. What would Strickler's cash conversion cycle, total assets turnover, and ROA have been if the inventory turnover had been 8 for the year? Do not round intermediate calculations. Round your answers to two decimal places. Cash conversion cycle: days Total assets turnover: ROA: % Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,395,000 (all on credit), and its net profit margin was 4%. Its inventory turnover was 5.0 times during the year, and its DSO was 43 days. Its annual cost of goods sold was $1,250,000. The firm had fixed assets totaling $355,000. Strickler's payables deferral period is 47 days. Assume a 365-day year. Do not round intermediate calculations. a. Calculate Strickler's cash conversion cycle. Do not round intermediate calculations. Round your answer to two decimal places. days b. Assuming Strickler holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. Do not round intermediate calculations. Round your answers to two decimal places. Total assets turnover: ROA: % c. Suppose Strickler's managers believe the annual inventory turnover can be raised to 8 times without affecting sale or profit margins. What would Strickler's cash conversion cycle, total assets turnover, and ROA have been if the inventory turnover had been 8 for the year? Do not round intermediate calculations. Round your answers to two decimal places. Cash conversion cycle: days Total assets turnover: ROA: %

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

Finance Applications And Theory

Authors: Marcia Cornett, Troy Adair, John Nofsinger

2nd Edition

0073530670, 9780073530673

More Books

Students also viewed these Finance questions