2.99 See Answer

Question: Using Tables 3.1, 3.2, and

Using Tables 3.1, 3.2, and 3.3, conduct a complete ratio analysis of the Bartlett Company for the years 2018 and 2019. You should assess the firm’s liquidity, activity, debt, and profitability ratios. Highlight any particularly positive or negative developments that you uncover when comparing ratios from 2018 and 2019. Tables 3.1:
Using Tables 3.1, 3.2, and 3.3, conduct a complete ratio analysis of the Bartlett Company for the years 2018 and 2019. You should assess the firm’s liquidity, activity, debt, and profitability ratios. Highlight any particularly positive or negative developments that you uncover when comparing ratios from 2018 and 2019.

Tables 3.1:

Tables 3.2:

Tables 3.3:

Tables 3.2:
Using Tables 3.1, 3.2, and 3.3, conduct a complete ratio analysis of the Bartlett Company for the years 2018 and 2019. You should assess the firm’s liquidity, activity, debt, and profitability ratios. Highlight any particularly positive or negative developments that you uncover when comparing ratios from 2018 and 2019.

Tables 3.1:

Tables 3.2:

Tables 3.3:

Tables 3.3:
Using Tables 3.1, 3.2, and 3.3, conduct a complete ratio analysis of the Bartlett Company for the years 2018 and 2019. You should assess the firm’s liquidity, activity, debt, and profitability ratios. Highlight any particularly positive or negative developments that you uncover when comparing ratios from 2018 and 2019.

Tables 3.1:

Tables 3.2:

Tables 3.3:

Transcribed Image Text:

For the years ended December 31 2019 2018 $3,074 2,088 $ 986 Sales revenue $2,567 Less: Cost of goods sold Gross profits Less: Operating expenses 1,711 $ 856 Selling expense $ 100 $ 108 General and administrative expenses 194 187 Other operating expenses Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes 35 35 239 223 $ 568 $ 418 $ 553 $ 303 93 91 $ 325 $ 212 Less: Taxes 94 64 Net profits after taxes $ 231 $ 148 Less: Preferred stock dividends 10 10 Earnings available for common stockholders $ 221 $ 138 Earnings per share (EPS)ª Dividend per share (DPS)* $2.90 $1.81 $1.29 $0.75 December 31 Assets 2019 2018 Cash $ 363 $ 288 Marketable securities 68 51 Accounts receivable 503 365 Inventories 289 300 $1,004 $1,903 Total current assets $1,223 $2,072 Land and buildings Machinery and equipment 1,866 1,693 Furniture and fixtures 358 316 Vehicles 275 314 Other (includes financial leases) 98 96 Total gross fixed assets (at cost) $4,669 $4,322 Less: Accumulated depreciation 2,295 $2,374 2,056 $2,266 $3,270 Net fixed assets Total assets $3,597 Liabilities and Stockholders' Equity $ 382 $ 270 Accounts payable Notes payable 79 99 Accruals 159 114 $ 620 1,023 $1,643 $ 200 Total current liabilities $ 483 Long-term debt (includes financial leases) 967 $1,450 $ 200 Total liabilities Preferred stock: cumulative 5%, $100 par, 2,000 shares authorized and issued Common stock: $2.50 par, 100,000 shares authorized, shares issued and outstanding in 2019: 76,262; in 2018: 76,244 Paid-in capital in excess of par on common stock 191 191 428 417 Retained earnings Total Stockholders' Equity 1,135 $1,954 $3,597 1,012 $1,820 $3,270 Total liabilities and stockholders' equity Retained earnings balance (January 1, 2019) Plus: Net profits after taxes (for 2019) Less: Cash dividends (paid during 2019) $1,012 231 Preferred stock 10 Common stock 98 $ 108 Total dividends paid Retained carnings balance (December 31, 2019) $1,135

> Using the information provided in the following table, find the value of each asset today. Cash flow Asset Year Amount Appropriate required return A $ 3,000 1 8% 2 3,000 3 3,000 1 through oo $ 500 5% C 1 6% 2 4 5 45,000 $ 1,500 8,500 D 1 through 5 4

> Weekend Warriors Inc. has 35% debt and 65% equity in its capital structure. The firm’s estimated after-tax cost of debt is 8% and its estimated cost of equity is 13%. Determine the firm’s weighted average cost of capital (WACC).

> Imagine that you are trying to evaluate the economics of purchasing a condominium to live in during college rather than renting an apartment. If you buy the condo, during each of the next 4 years you will have to pay property taxes and maintenance expend

> Assume that the Financial Management Corporation’s $1,000-par-value bond had a 5.700% coupon, matures on May 15, 2027, has a current price quote of 97.708, and has a yield to maturity (YTM) of 6.034%. Given this information, answer the following question

> Charter Corp. has issued 2,500 debentures with a total principal value of $2,500,000. The bonds have a coupon rate of 7%. a. What dollar amount of interest per bond can an investor expect to receive each year from Charter? b. What is Charter’s total inte

> Carl Foster, a trainee at an investment banking firm, is trying to get an idea of what real rate of return investors are expecting in today’s marketplace. He has looked up the rate paid on 3-month U.S. Treasury bills and found it to be 1.5%. He has decid

> A person borrows $200 that he must repay in a lump sum no more than 8 years from now. The interest rate is 8.5% annually compounded. The borrower can repay the loan at the end of any earlier year with no prepayment penalty. a. What amount will be due if

> Misty needs to have $15,000 in 5 years to fulfill her goal of purchasing a small sailboat. She is willing to invest a lump sum today and leave the money untouched for 5 years until it grows to $15,000, but she wonders what sort of investment return she w

> You can deposit $10,000 into an account paying 9% annual interest either today or exactly 10 years from today. How much better off will you be 40 years from now if you decide to make the initial deposit today rather than 10 years from today?

> As part of your financial planning, you wish to purchase a new car 5 years from today. The car you wish to purchase costs $14,000 today, and your research indicates that its price will increase by 2% to 4% per year over the next 5 years. a. Estimate the

> You have $1,500 to invest today at 7% interest compounded annually. a. Find how much you will have accumulated in the account after (1) 3 years, (2) 6 years, and (3) 9 years. b. Use your findings in part a to calculate the amount of interest earned in (1

> For each of the cases shown in the following table, calculate the future value of the single cash flow deposited today and held until the end of the deposit period if the interest is compounded annually at the rate specified. Single cash flow Deposi

> Duke Energy has been paying dividends steadily for 20 years. During that time, dividends have grown at a compound annual rate of 3%. If Duke Energy’s current stock price is $78 and the firm plans to pay a dividend of $6.50 next year, what is the required

> You have $100 to invest. If you put the money into an account earning 5% interest compounded annually, how much money will you have in 10 years? How much money will you have in 10 years if the account pays 5% simple interest?

> Suppose that today’s date is January 1, 2019. You have the opportunity to make an investment that will pay you $100 on January 1 of every year, starting in 2020 and continuing forever. Assume the relevant discount rate is 7%. a. What would you pay now fo

> Consider the data in the following table. Determine the present value of each perpetuity. Perpetuity Annual payment Discount rate A $ 20,000 8% В 100,000 10 C 3,000 6. D 60,000 5

> Assume that you just won the state lottery. Your prize can be taken either in the form of $40,000 at the end of each of the next 25 years (i.e., $1,000,000 over 25 years) or as a single amount of $500,000 paid immediately. a. If you expect to earn 5% ann

> Emily Jacob is 45 years old and has saved nothing for retirement. Fortunately, she just inherited $75,000. Emily plans to put a large portion of that money into an investment account earning an 11% return. She will let the money accumulate for 20 years,

> An insurance agent is trying to sell you an annuity that will provide you with $12,000 at the end of each of the next 25 years. If you don’t purchase this annuity, you can invest your money and earn a return of 9%. What is the most you would pay for this

> Hal Thomas, a 25-year-old college graduate, wishes to retire at age 65. To supplement other sources of retirement income, he can deposit $2,000 each year into a tax-deferred individual retirement arrangement (IRA). The IRA will earn a 10% return over the

> Marian Kirk wishes to select the better of two 10-year annuities. Annuity 1 is an ordinary annuity of $2,500 per year for 10 years. Annuity 2 is an annuity due of $2,300 per year for 10 years. a. Find the future value of both annuities 10 years from now,

> Consider the following cases. a. Calculate the present value of the annuity, assuming that it is (1) An ordinary annuity. (2) An annuity due. b. Compare your findings in parts a(1) and a(2). All else being identical, which type of annuityâ€&

> Future value calculation  Without referring to the preprogrammed function on your financial calculator, use the basic formula for future value along with the given interest rate, r, and the number of periods, n, to calculate the f

> Your firm, People’s Consulting Group, has been asked to consult on a potential preferred stock offering by Brave New World. This 9% preferred stock issue would be sold at its par value of $55 per share. Flotation costs would total $3 per share. Calculate

> For each case in the accompanying table, answer the questions that follow. a. Calculate the future value of the annuity, assuming that it is (1) An ordinary annuity. (2) An annuity due. b. Compare your findings in parts a(1) and a(2). All else being id

> You put $10,000 in an account earning 5%. After 3 years, you make another deposit into the same account. Four years later (that is, 7 years after your original $10,000 deposit), the account balance is $20,000. What was the amount of the deposit at the en

> Tom Alexander has an opportunity to purchase any of the investments shown in the following table. The purchase price, the amount of the single cash inflow, and its year of receipt are given for each investment. Which purchase recommendations would you ma

> In exchange for a $23,000 payment today, a well-known company will allow you to choose one of the alternatives shown in the following table. Your opportunity cost is 9%. a. Find the value today of each alternative. b. Are all the alternatives acceptabl

> You just won a lottery that promises to pay you $1,000,000 exactly 10 years from today. A company approaches you today, offering cash in exchange for your winning lottery ticket. a. What is the least you will sell your claim for if you can earn the follo

> An Iowa state savings bond can be converted to $100 at maturity 6 years from purchase. If the state bonds are to be competitive with U.S. savings bonds, which pay 3% annual interest (compounded annually), at what price must the state sell its bonds? Assu

> Jim Nance has been offered an investment that will pay him $500 three years from today. a. If his opportunity cost is 7% compounded annually, what value should he place on this opportunity today? b. What is the most he should pay to purchase this investm

> Answer each of the following questions. a. How much money would you have to invest today to accumulate $6,000 after 6 years if the rate of return on your investment is 12%? b. What is the present value of $6,000 that you will receive after 6 years if the

> For each of the cases shown in the following table, calculate the present value of the cash flow, discounting at the rate given and assuming that the cash flow is received at the end of the period noted. Single cash flow End of period (ycars) Cash D

> Without referring to the preprogrammed function on your financial calculator, use the basic formula for present value, along with the given discount rate, r, and the number of periods, n, to calculate the present value of $1 in each of the cases shown in

> A firm raises capital by selling $20,000 worth of debt with flotation costs equal to 2% of its par value. If the debt matures in 10 years and has a coupon interest rate of 8% (paid annually), what is the bond’s YTM?

> The financial manager at Starbuck Industries is considering an investment that requires an initial outlay of $25,000 and is expected to produce cash inflows of $3,000 at the end of year 1, $6,000 at the end of years 2 and 3, $10,000 at the end of year 4,

> Maris Brothers Inc. needs a cash disbursement schedule for the months of April, May, and June. Use the format of Table 4.9 and the following information in its preparation. Sales: February = $500,000; March = $500,000; April = $560,000; May = $610,000; J

> A firm has actual sales of $65,000 in April and $60,000 in May. It expects sales of $70,000 in June and $100,000 in July and in August. Assuming that sales are the only source of cash inflows and that half of them are for cash and the remainder are colle

>  Below we reproduce the stockholders’ equity section of the 2019 and 2018 balance sheets for Baker Corporation, which also appear as part. a. The Baker Corporation statement of cash flows shows a $0 cash inflow resulting f

> Use the appropriate items from the following list to prepare Mellark’s Baked Goods balance sheet at December 31, 2019. Value ($000) at December 31, 2019 Value ($000) at December 31, 2019 Item Item Accounts payable $ 220 Inventories

> Everdeen Mining Inc. ended 2019 with a net profit before taxes of $436,000. The company is subject to a 40% tax rate and must pay $64,000 in preferred stock dividends before distributing any earnings on the 170,000 shares of common stock currently outsta

> Adam and Arin Adams have collected their personal income and expense information and have asked you to put together an income and expense statement for the year ended December 31, 2019. You have received the following information from the Adams family.

> Consider the following balance sheets and selected data from the income statement of Keith Corporation. a. Calculate the firm’s net operating profit after taxes (NOPAT) for the year ended December 31, 2019, using Equation 4.1. b. Ca

> McDougal Printing Inc. had sales totaling $40,000,000 in fiscal year 2019. Some ratios for the company are listed below. Use this information to determine the dollar values of various income statement and balance sheet accounts as requested. Calculate

> Financial information from fiscal year 2016 for two companies competing in the cosmetics industry—The Estée Lauder Companies and e.l.f. Beauty Inc.—appears in the table below. All dollar values are in tho

> You wish to calculate the risk level of your portfolio based on its beta. The five stocks in the portfolio with their respective weights and betas are shown in the accompanying table. Calculate the beta of your portfolio. Stock Portfolio weight Beta

> Pelican Paper Inc. and Timberland Forest Inc. are rivals in the manufacture of craft papers. Some financial statement values for each company follow. Use them in a ratio analysis that compares the firms’ financial leverage and profitabi

> On December 31, 2019, Cathy Chen, a self employed certified public accountant (CPA), completed her first full year in business. During the year, she charged her clients $360,000 for accounting services. She had two employees, a bookkeeper and a clerical

> Common-size statement analysis A common-size income statement for Creek Enterprises’ 2018 operations follows. Using the firm’s 2019 income statement presented in Problem 3–16, develop the

> The table below shows 2016 total revenues, cost of goods sold, earnings available for common stockholders, total assets, and stockholders’ equity for three companies competing in the bottled drinks market: The Coca-Cola Company, Pepsico

> Springfield Bank is evaluating Creek Enterprises, which has requested a $4,000,000 loan, to assess the firm’s financial leverage and financial risk. On the basis of the debt ratios for Creek, along with the industry average and Creek&ac

> The table below shows key financial data for three firms that compete in the consumer products market: Procter & Gamble, Colgate-Palmolive, and Clorox. All dollar values are in thousands. a. Calculate each of the following ratios for all three comp

> The table below shows that Blair Supply had an end-of-year accounts receivable balance of $300,000. The table also shows how much of the receivables balance originated in each of the previous 6 months. The company had annual sales of $2.4 million, and it

> Classify each of the following items as an inflow (I) or an outflow (O) of cash. Item Change ($) Item Change ($) Cash -300 Accounts receivable +1,700 Accounts payable Notes payable Long-term debt Inventory Fixed assets Net profits Depreciation Repur

> Three companies that compete in the footwear market are Foot Locker, Finish Line, and DSW. The table below shows inventory levels and cost of goods sold for each company for the 2016, 2015, and 2014 fiscal years. Calculate the inventory turnover ratio fo

> Your portfolio has three asset classes. U.S. government T-bills account for 45% of the portfolio, large-company stocks constitute another 40%, and small-company stocks make up the remaining 15%. If the expected returns are 2% for the T-bills, 10% for the

> Josh Smith has compiled some of his personal financial data to determine his liquidity position. The data are as follows. a. Calculate Josh’s liquidity ratio. b. Several of Josh’s friends have told him that they have

> Bauman Company’s total current assets, total current liabilities, and inventory for each of the past 4 years follow: a. Calculate the firm’s current and quick ratios for each year. Compare the resulting time series f

> Robert Arias recently inherited a stock portfolio from his uncle. Wishing to learn more about the companies in which he is now invested, Robert performs a ratio analysis on each one and decides to compare them to one another. Some of his ratios are liste

> Mark each of the accounts listed in the following table as follows: a. In column (1), indicate in which statement—income statement (IS) or balance sheet (BS)—the account belongs. b. In column (2), indicate whether the

> During the year just ended, Shering Distributors, Inc., had pretax earnings from operations of $490,000. In addition, during the year it received $20,000 in income from interest on bonds it held in Zig Manufacturing and received $20,000 in income from di

> Using the corporate tax rate schedule given in Table 1.2, perform the following: a. Find the marginal tax rate for the following levels of corporate earnings before taxes: $15,000; $60,000; $90,000; $200,000; $400,000; $1 million; and $20 million. b. Plo

> Using the corporate tax rate schedule given in Table 1.2, perform the following: a. Calculate the tax liability, after-tax earnings, and average tax rates for the following levels of corporate earnings before taxes: $10,000; $80,000; $300,000

> Tantor Supply, Inc., is a small corporation acting as the exclusive distributor of a major line of sporting goods. During 2017, the firm earned $92,500 before taxes. a. Calculate the firm’s tax liability using the corporate tax rate sch

> The Securities Exchange Act of 1934 limits, but does not prohibit, corporate insiders from trading in their own firm’s shares. What ethical issues might arise when a corporate insider wants to buy or sell shares in the firm where he or she works?

> A firm in the third year of depreciating its only asset, which originally cost $180,000 and has a 5-year MACRS recovery period, has gathered the following data relative to the current year’s operations. a. Use the relevant data to det

> The expected annual returns are 15% for investment 1 and 12% for investment 2. The standard deviation of the first investment’s return is 10%; the second investment’s return has a standard deviation of 5%. Which investment is less risky based solely on i

> Denim Industries can borrow its needed financing for expansion using one of two foreign lending facilities. It can borrow at a nominal annual interest rate of 8% in Mexican pesos, or it can borrow at 3% in Canadian dollars. If the peso is expected to dep

> A Brazilian company called Netshoes completed its IPO on April 12, 2017, and listed on the NYSE. Netshoes sold 8,250,000 shares of stock to primary market investors at an IPO offer price of $18, with an underwriting discount of 6.5%. Secondary market inv

> On April 13, 2017, Yext Inc. completed its IPO on the NYSE. Yext sold 10,500,000 shares of stock at an offer price of $11 with an underwriting discount of $0.77 per share. Yext’s closing stock price on the first day of trading on the secondary market was

> In late December you decide, for tax purposes, to sell a losing position that you hold in Twitter, which is listed on the NYSE, so that you can capture the loss and use it to offset some capital gains, thus reducing your taxes for the current year. Howev

> Explain why each of the following situations is an agency problem and what costs to the firm might result from it. Suggest how the problem might be handled short of firing the individual(s) involved. a. The front desk receptionist routinely takes an extr

> Ken Allen, capital budgeting analyst for Bally Gears, Inc., has been asked to evaluate a proposal. The manager of the automotive division believes that replacing the robotics used on the heavy truck gear line will produce total benefits of $560,000 (in t

>  It is typical for Jane to plan, monitor, and assess her financial position using cash flows over a given period, typically a month. Jane has a savings account, and her bank loans money at 6% per year while it offers short-term investment rat

> Thomas Book Sales, Inc., supplies textbooks to college and university bookstores. The books are shipped with a proviso that they must be paid for within 30 days but can be returned for a full refund credit within 90 days. In 2018, Thomas shipped and bill

> Merideth Harper has invested $25,000 in Southwest Development Company. The firm has recently declared bankruptcy and has $60,000 in unpaid debts. Explain the nature of payments, if any, by Merideth in each of the following situations. a. Southwest Develo

> What does it mean to say that managers should maximize shareholder wealth “subject to ethical constraints”? What ethical considerations might enter into decisions that result in cash flow and stock price effects that are less than they might otherwise ha

> Hemingway Corporation is considering expanding its operations to boost its income, but before making a final decision, it has asked you to calculate the corporate tax consequences of such a decision. Currently, Hemingway generates before tax yearly incom

> Four analysts cover the stock of Fluorine Chemical. One forecasts a 5% return for the coming year. The second expects the return to be –5%. The third predicts a 10% return. The fourth expects a 3% return in the coming year. You are relatively confident t

> Pavlovich Instruments Inc., a maker of precision telescopes, expects to report pretax income of $430,000 this year. The company’s financial manager is considering the timing of a purchase of new computerized lens grinders. The grinders will have an insta

> Michaels Corporation expects earnings before interest and taxes to be $50,000 for the current period. Assuming a flat ordinary tax rate of 35%, compute the firm’s earnings after taxes and earnings available for common stockholders (earnings after taxes a

> You would like to purchase one Class A share of Berkshire Hathaway through your Scottrade brokerage account. Scottrade charges a $7 commission for online trades. You log into your account, check the real-time quotes for Berkshire Hathaway (you see a bid

> Home Health Inc. has come to Jane Ross for a yearly financial checkup. As a first step, Jane has prepared a complete set of ratios for fiscal years 2018 and 2019. She will use them to look for significant changes in the company’s situat

> Use the following 2016 financial information for ATT and Verizon to conduct a DuPont system of analysis for each company. a. Which company has the higher net profit margin? Higher asset turnover? b. Which company has the higher ROA? The higher ROE?

> Given the following financial statements, historical ratios, and industry averages, calculate Sterling Company’s financial ratios for the most recent year. (Assume a 365-day year.) Analyze its overall financial situation from both a

> The financial statements of Zach Industries for the year ended December 31, 2019, follow. a. Use the preceding financial statements to complete the following table. Assume that the industry averages given in the table are applicable for both 2018 and

> Use the accompanying financial statements for Fox Manufacturing Company for the year ended December 31, 2019, along with the industry average ratios below, to do the following: a. Prepare and interpret a complete ratio analysis of the firmâ€&#

> The SEC is trying to get companies to notify the investment community more quickly when a “material change” will affect their forthcoming financial results. In what sense might a financial manager be seen as “more ethical” if he or she follows this direc

> Provincial Imports Inc. has assembled past (2019) financial statements (income statement and balance sheet below) and financial projections for use in preparing financial plans for the coming year (2020). Information related to financial projections f

> An analyst predicted last year that the stock of Logistics Inc. would offer a total return of at least 10% in the coming year. At the beginning of the year, the firm had a total stock market capitalization of $10 million. At the end of the year, its mark

> Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. The following financial data are also available: (1) The firm has estimated that its sales for

> In early 2019, Sosa Enterprises purchased a new machine for $10,000 to make cork stoppers for wine bottles. The machine has a 3-year recovery period and is expected to have a salvage value of $2,000. Develop a depreciation schedule for this asset using t

> Peabody & Peabody has 2019 sales of $10 million. It wishes to analyze expected performance and financing needs for 2021, which is 2 years ahead. Given the following information, respond to parts a and b. (1) The percent of sales for items that vary d

> Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total $3,000,000. The following information has been gathered: (1) A minimum cash balance of $50,000 is desired. (2) Marketable securitie

> Allen Products Inc. wants to do a scenario analysis for the coming year. The pessimistic prediction for sales is $900,000; the most likely amount of sales is $1,125,000; and the optimistic prediction is $1,280,000. Allen’s income statem

> The marketing department of Metroline Manufacturing estimates that its sales in 2020 will be $1.5 million. Interest expense is expected to remain unchanged at $35,000, and the firm plans to pay $70,000 in cash dividends during 2020. Metroline Manufacturi

> Brownstein Inc. expects sales of $100,000 during each of the next 3 months. It will make monthly purchases of $60,000 during this time. Wages and salaries are $10,000 per month plus 5% of sales. Brownstein expects to make a tax payment of $20,000 in the

>  Trotter Enterprises Inc. has gathered the following data to plan for its cash requirements and short-term investment opportunities for October, November, and December. All amounts are shown in thousands of dollars. a. Prepare a scenario an

> The following represent financial transactions that Johnsfield & Co. will be undertaking in the next planning period. For each transaction, check the statement or statements that will be affected immediately. Statement Pro forma balance sheet Pr

> The actual sales and purchases for Xenocore Inc. for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020, follow. The firm makes 20% of all sales for cash and collects on 40% of its sale


See Answer