SPREADSHEET PROBLEMS1. If a firm's net income (profits before taxes) is $120,000 and it has total assets of $1.5million, what is its return on assets?2. If a firm's total assets is $2.5 million and its return on assets is 12 percent, what is itsnet income?3. If a firm is able to sustain the same level of operations in terms of sales andadministrative expenses but reduces its materials cost by $50,000 through smarterpurchases, what is the profit-leverage effect on gross profits? What is the profit-leverage effect on profits before taxes?4. If a firm's cost of goods sold is $2.5 million and its average inventory is $500,000, whatis the inventory turnover?5. If a firm's cost of goods sold is $5 million and its inventory turnover is ten times, whatis the average inventory?6. If a firm's inventory turnover is eight times and its average inventory is $160,000, whatis the cost of goods sold?7. A retailer in Las Vegas has an ending inventory of $250,000 as of December 31, 2016,and the following accounting information.ENDING INVENTORYCOST OF GOODS SOLDMONTHJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember$225,000$325,000$240,000$325,000$460,000$220,000S85,000$156.000$220,000$265,000$100,000$350.000$1.200,000$1.250,000$1,350,000$1,500,000$950,000$850,00$1.650,000$1,325,000$1,750,000$850,000$2,200,000$3.500.000a. Compute the monthly inventory turnover ratio for each of the twelve months,b. What are the annual cost of goods sold and the average inventory for the year?c. Compute the annual inventory turnover ratio. How is the retailer's performancecompare to the industry standard, assuming its business is similar to Walmart's?

Answered: 1. If a firm's net income (profits…

1. If a firm's net income (profits before taxes) is $120,000 and it has total assets of $1.5 million, what is its return on assets?

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter2: Financial Statements And The Annual Report

Section: Chapter Questions

Problem 2.5AP: Working Capital and Current Ratio The balance sheet of Kapinski Inc. includes the following items:...

See similar textbooks

Related questions

Q: This year, FCF Inc. has earnings before interest and taxes of $10,180,000, depreciation expenses of…

A: Free cash flow = EBIT*(1-tax) + Deprication - capital expenditure - Increase in Working capital

Q: So Long, Inc, has sales of $334,000, costs of $145,400, depreciation expense of S63,200 and interest…

A: Note: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: The Sunflower Corporation reported the following information from their financial statements:…

A: Dollar amount of taxes the firm had to pay to the taxation office is the amount that is applicable…

Q: So Long, Inc, has sales of $334,000, costs of $145,400, depreciation expense of $63,200 and interest…

A: The question is based on the concept of Financial Management.

Q: Suppose a firm has the following information: Sales = $10million; costs of goods sold (excluding…

A: Computation:

Q: SSSSS’ operating income (EBIT) is P500,000. The company’s tax rate is 40 percent, and its operating…

A: Hi, Thanks for the Question Since you asked multiple questions, we will answer the first question…

Q: Leo's Corp has sales of $ 684,000, operating expenses of $ 437,000, interest expense of $ 13,800,…

A: Ratio analysis: This is the quantitative analysis of financial statements of a business enterprise.…

Q: If a company has $17,000 in liabilities and $2,500 in equity, then what is the amount of its assets?

A: Accounting equation:Assets = Liabilities + Stockholder\'s equityHere, Liabilities = 17000Equity =…

Q: A firm’s total net operating capital for the previous year was$9.3 million. For the current year,…

A: Free cash flows refers to the amount which is left after paying operating expenses and capital…

Q: Company Zeta had retained earnings balance of $4 million in the previous year. In the current year,…

A: Retained earnings are the portion of income which is held by the company for the future operating…

Q: A firm has the following information: $2 million in earningsbefore taxes. The firm has an interest…

A: Earnings before interest, depreciation and taxes are the operating income earned by the company…

Q: Butterfly Tractors had $14.50 million in sales last year. Cost of goods sold was $8.10 million,…

A: The Numerical has covered the concept of Calculating Net Cash Flow and Income statement. The Income…

Q: Your company has current assets of $250 million, total assets of $395 million and long term debt of…

A: Current Assets = $250 Million Total Assets = $395 Million Long term debt = $116 Million Net…

Q: A firm had gross profits from sales in the amountof $180,000, operating expenses of $90,000,and…

A: Net Income is defined as the aggregate amount of money that the business earned in the time period,…

Q: what is net income? What is ROA? What is ROE?

A: Net Income: It represents the amount of profits/gains made by the company after the reduction of…

Q: Tibbs Inc. had the following data for the most recent year: Net income = $300; Net operating profit…

A: Return on Invested capital is the return or net income after taxes earned on the invested capital…

Q: A firm paid R800 000 in dividends over the last period. The beginning and ending retained earnings…

A: Formula: Net income after taxes = Total dividends paid + Change in retained earnings

Q: The Firm had sales of $33 million, operating expenses of $14 million, interest of $4 million and…

A: Net Income: The net income of the business is determined by subtracting the total expenses from the…

Q: For a company that had net operating income of $51.3 million and operating expenses of $23.6…

A: Gross income is the sum of incomes received in terms of interest, salary, wages, commission, rents…

Q: A company’s income statement shows interest expense of $5 million, sales revenue of $50 million,…

A: Interest coverage ratio is used to find how easily a company can pay its interest on outstanding…

Q: Last year Rattner Robotics had $5 million in operating income (EBIT). Its depreciation expense was…

A: a. Net income=(EBIT-Interest)×(1-tax rate)=$5,000,000-$1,000,000×1-0.40=$2,400,000

Q: The Moore Corporation has operating income (EBIT) of $750,000. The company’s depreciation expense is…

A: Net income is calculated by using the following formula: NI = (EBIT - Interest) * (1 - tax rate) Net…

Q: A firm paid R800 000 in dividends over the last period. The beginning and ending retained earnings…

A: A firm paid R 800 000 in dividends over the last period. The beginning and ending retained earnings…

Q: A company has $6 billion of net income, $2 billion of depreciationand amortization, $80 billion of…

A: Given data; Net income = $6 billion Depreciation and amortization = $2 billion common equity = $80…

Q: A firm has $ 1.2 million in current assets and $ 1 million in current liabilities. If the company…

A: Current Ratio: A current ratio is a calculation that provides the relation between current assets…

Q: Taurus Inc, has sales of $540,000, costs of $225,150, depreciation expense of $48,400, interest…

A: Sales = 540,000 Costs = 225,150 Depreciation = 48,400 Interest expense = 37,000 Other expenses =…

Q: A firm has net sales of $3,000, cash expenses (including taxes) of $1,400, and depreciation of $500.…

A: Given information: Net sales = $3,000 Cash expenses = $1,400 Depreciation expense = $500 Increase in…

Q: A firm had a retained earnings balance of $3 million in the previousyear. In the current year, its…

A: Retained earnings are the accumulated earnings which are retained by the company to use for…

Q: Carlton West Oil Company, LLC had sales revenue of $500,000, operating expenses of $400,000, no…

A: The asset Utilization ratio measures the value of a company's sales or revenue relative to the value…

Q: b. What is the change in net working capital for year t? Change in net working capital c. In year…

A: Hi student Since there are multiple subparts, we will answer only first three subparts. If you want…

Q: A debt-free firm has profit for the year of $128 400, taxes of $46 200 and depreciation of $21 300.…

A: Profit = $ 128,400 Taxes = $ 46,200 Depreciation = $ 21,300

Q: A firm had after-tax income last year of $2.1 million. Its depreciation expenses were $0.5 million,…

Q: If the net income after tax of the company is P4,000,00O, starting balance of assets is P500,000 and…

A: "Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: If for the most recent year, a firm's RNOA is 12.0%, its sales were $2,400,000, its asset turnover…

A: ROCE stands for "Return On Capital Employed". It is computed by dividing EBIT by the (total assets -…

Q: erhad has the following income statement items for 2021: Revenue/Sales RM4,801,139 Finance…

A: We need to compute earnings before tax.

Q: Assume that Taco Bell company reported operating income of $5.15 million, $0.7 million in other…

A: Operating Income Add Other Income Less Other expenses and losses Profit before taxes…

Q: A firm has net income of $21,350, depreciation of $2,780, interest of $640, and taxes of $10,990.…

A: We can calculate the value of the firm by using the EBITDA and EBITDA Multiple. We will first…

Q: Assume a corporation has earnings before depreciation and taxes of $82,000, depreciation of $45,000,…

A: For calculating after tax cashflow of a company we add back deprecation to after tax income.

Q: Your firm has the following income statement items: sales of $50,250,000; income tax of $1,744,000;…

A: Sales = $50,250,000 Income tax = $1,744,000 Operating expenses = $10,115,000 COGS = $35,025,000…

Q: Building an Income Statement Gia, Inc., has sales of $473,000, costs of $275,000, depreciation…

A: Shown below

Q: Your firm has the following income statement items: sales of $52,000,000; income tax of $1,880,000;…

A: For the purpose of computing the cash flow from operations: 1. Any non-cash income or expense needs…

Q: companys income before interest expense and income taxes is 175,000 and its inerest expense is…

A: Times interest earned ratio will calculated using Interest expense and PBIT

Q: A firm’s annual revenues are $850,000. Its expenses for the year are $615,000, and it claims…

A: Tax:- It is the amount which one pays to the government of the country as per prescribed rates or…

Q: 3. ENN Corporation has interest expense of P16,000, sales of P600,000, a taxrate of 30%, and…

A: Dear You have asked 2 questions in one slot. So, I have solved 1st means Question no. 3 as per…

Q: b) The Moore Corporation has operating income (EBIT) of $750,000. The company’s depreciation expense…

A: Net income = (EBIT - interest) x (1 - tax rate)EBIT = $ 750,000As compnay is 100% equity finance,…

Q: What is the operating cash flow for a firm with $500,000 profit before tax, $100,000 depreciation…

A: Operating cash flow refers to the cash generated from the operations of a business. It does not…

Question

SPREADSHEET PROBLEMS
1. If a firm's net income (profits before taxes) is $120,000 and it has total assets of $1.5
million, what is its return on assets?
2. If a firm's total assets is $2.5 million and its return on assets is 12 percent, what is its
net income?
3. If a firm is able to sustain the same level of operations in terms of sales and
administrative expenses but reduces its materials cost by $50,000 through smarter
purchases, what is the profit-leverage effect on gross profits? What is the profit-
leverage effect on profits before taxes?
4. If a firm's cost of goods sold is $2.5 million and its average inventory is $500,000, what
is the inventory turnover?
5. If a firm's cost of goods sold is $5 million and its inventory turnover is ten times, what
is the average inventory?
6. If a firm's inventory turnover is eight times and its average inventory is $160,000, what
is the cost of goods sold?
7. A retailer in Las Vegas has an ending inventory of $250,000 as of December 31, 2016,
and the following accounting information.
ENDING INVENTORY
COST OF GOODS SOLD
MONTH
January
February
March
April
May
June
July
August
September
October
November
December
$225,000
$325,000
$240,000
$325,000
$460,000
$220,000
S85,000
$156.000
$220,000
$265,000
$100,000
$350.000
$1.200,000
$1.250,000
$1,350,000
$1,500,000
$950,000
$850,00
$1.650,000
$1,325,000
$1,750,000
$850,000
$2,200,000
$3.500.000
a. Compute the monthly inventory turnover ratio for each of the twelve months,
b. What are the annual cost of goods sold and the average inventory for the year?
c. Compute the annual inventory turnover ratio. How is the retailer's performance
compare to the industry standard, assuming its business is similar to Walmart's?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Define profitability raitos return on assets and return on equity. According to the following metrics: ROA Return on Assets: 14%; ROE Return on Equity: 305%. What is the profitability the of example company? Why or why not is this company profitable?
Answer this questions: 1. If the revenue is Php 94,810 and total expenses are Php 80,537, what is the net income? 2. If sales are equal to Php 600,480 and the costs of goods sold is equal to Php 374,789, what is the gross profit/margin? 3. If the company B has Php 1.048,150 liabilities, how much is its equity? 4. Given the following information, compute for the operating profit/margin: GROSS SALES: Php 600,480 COSTS OF GOODS SOLD: Php 374,789 TOTAL OPERATING EXPENSES: Php 132,916 5. A company's total investements Php 1,500,000. If Return on Investments is 35% , how much is the net profit after taxes?
5. Anderson Inc. has sales of $17.6 million, total assets of $13.5 million, and total debt of $6.2 million. If profit margin is 5.2%, what is net income? What is ROA? What is ROE?
A firm’s income statement included the following data. The firm’s average tax rate was 25%. Cost of goods sold $ 8,900 Income taxes paid 2,900 Administrative expenses 3,900 Interest expense 1,900 Depreciation 1,900 a. What was the firm’s net income? Net income $ b. What must have been the firm’s revenues? Revenues $ c. What was EBIT? EBIT $
Working Capital and Current Ratio The balance sheet of Kapinski Inc. includes the following items: Required Determine the current ratio and working capital. Kapinski appears to have a positive current ratio and a large net working capital. Why would it have trouble paying bills as they come due? Suggest three things that Kapinski can do to help pay its bills on time.
DTO, Inc., has sales of $32 million, total assets of $25 million, and total debt of $7 million. a. If the profit margin is 6 percent, what is the net income? b. What is the ROA? c. What is the ROE?
Question 2. Below are the operating income on sales ratios for three international companies: Year Company A Company B Company C 2014 4 4 4 2015 5 6 7 2016 8 7 7 2017 5 8 8 2018 4 8 9 Required: Which company is more profitably over the years? Measure the stability of this ratio? Advise the investor on which company he should invest in?
Which of the following statements are true about profitability ratios? Check all that apply. If a company has a net profit margin of 10%, it means that the company earned a net income of $0.10 for each dollar of sales. If a company’s operating margin increases but its profit margin decreases, it could mean that the company paid more in interest or taxes. An increase in the return on assets ratio implies an increase in the assets a firm owns. If a company issues new common shares but its net income does not increase, return on common equity will increase.
A firm has Capital of GHS 10,00,000; Sales of GHS 5,00,000; Gross Profit of GHS 2,00,000 and Expenses of GHS 1,00,000. What is the Net Profit Ratio?
consider a company with sales of $18,000.0 million, cost of goods sold of 42% of sales, other expenses including salaries ( we usually call this SG&A for selling, general and administrative) of 1750.0million, depreciation of 2250.0 million, and interest expense of 2300 million. tax rate =21%. a. generate an income statement and show net income b. what is the company's operating cash flow? c. if there are 775.2 million shares outstanding, what is the EPS? d. if the company has a payout ratio of 20%, what is the dividends per share?
. A firm has total sales of $64 million. It has gross profit of $12 million, operating income of $8.5 million, and net income of $8 million. a) What is the firm's net profit margin? b) If net profit increased to 15% from your answer in a), what percentage change does this represent?
Compute returns on assets for AT&T and Verizon and answer the question below. Be sure to show your work. Key figures($ millions). AT&T Verizon Sales 126,723 110,875 Net Income 4,184 10,198 Average Assets 269,868 225,233 AT&T Verizon Which company is more successful in returning net income from its assets invested?