Using the attached spreadsheet, construct a supply chain finance model by calculating P&L and Balance Sheets and the appropriate ratios and measures and calculate the profit margin; ROA; inventory turns; along with transportation, warehousing, and inventory cost as a percentage of sales (revenues) for the following: Baseline Sales Transportation cost Warehousing cost Inventory carrying rate Cost of goods sold Other operating costs Average inventory Cash Accounts receivable Net fixed assets Interest Tax rate Current liabilities Long-term Liabilities $200,000,000 $12,000,000 $3,000,000 0.31 $90,000,000 $50,000,000 $8,000,000 $15,000,000 $30,000,000 $90,000,000 $10,000,000 20%² $65,000,000 $35,000,000

Using the attached spreadsheet, construct a supply chain finance model by calculating P&L and Balance Sheets and the appropriate ratios and measures and calculate the profit margin; ROA; inventory turns; along with transportation, warehousing, and inventory cost as a percentage of sales (revenues) for the following: Baseline Sales Transportation cost Warehousing cost Inventory carrying rate Cost of goods sold Other operating costs Average inventory Cash Accounts receivable Net fixed assets Interest Tax rate Current liabilities Long-term Liabilities $200,000,000 $12,000,000 $3,000,000 0.31 $90,000,000 $50,000,000 $8,000,000 $15,000,000 $30,000,000 $90,000,000 $10,000,000 20%² $65,000,000 $35,000,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The analysis of a firm's liquidity includes all of the following except Multiple Choice Current ratio. Receivables turnover. Inventory turnover. Fixed asset turnover.
The income statement line gross profit will appear on which income statement format? Select one: a. Receipt and payment account b. Multiple step income statement c. Single step income statement d. Income and expenditure account
Carrying amounts in a GAAP balance sheet are measured using all the following except: Multiple Choice historical cost. net realizable value. discounted present value. projected ROI.
1. Which of the following is referred to as the Accounting Equation? Assets Liabilities + Equity Equity Liabilities + Assets Liabilities Assets + Equity Assets = Liabilities - Equity = 2. Which of the following make up the Finance Equation? (select all that apply) Revenues = Price x Volume Costs = Fixed + Variable Profit Revenues-Costs Income Sales - COGS
Discuss the following profitability ratios: Profit Margin, ROA-Return on Assets, ROI-Return on Investment, and the Gross Margin.
Which of the following is a solvency ratio? a. Times interest earned. b. Inventory turnover ratio. c. Profit margin. d. Price-earnings ratio.
Accounting: type question:,,,,,, While calculating purchase price, the following values of assets are considered A. Book value B. New values fixed C. Averagevalues D. Market values
A. Which of the following is most closely associated with the cost of using assets? a. Asset utilization b. Sales revenue c. Proportion of debt and equity d. Average price B. Which of the following is most closely associated with the return on management’s use of assets? a. Cost of capital b. Mix of equity types c. Prime lending rate d. # of products sold
_______ ratios are used to measure the speed in which various assets are converted into sales or cash. A Debt (aka Leverage) B Efficiency (aka working capital) C Profitability C Coverage
Financial statement that are expressed under a stable monetary unit are a. Constant peso financial statements b. Nominal peso financial statements c. Current cost financial statements d. Fair value financial statements
Which of the following increases the cash conversion cycle? A.A decrease in inventory turnover B.An increase in the cash discount C.An increase in accounts payable D.A decrease in inventory level
Which of the ratios listed helps to indicate whether current liabilities could be paid without having to sell the inventory? a.Current ratio b.Profit margin c.Quick ratio d.Debt to equity