Question

Please post in EXCEL format or from an EXCEL spreadsheet. Thank you

14. [EXCEL] Cash flows: Del Bridge Construction had long-term assets before depreciation of $990,560 on December 31, 2016 and $1,211,105 on December 31, 2017. How much cash flow was invested in long-term assets by Del Bridge during 2017?

17. [EXCEL] Tax: Manz Property Management Company announced that in the year ended June 30, 2017, its earnings before taxes amounted to $1,478,936. Calculate its taxes using Exhibit 3.6.

18. [EXCEL] Balance sheet: Tim Dye, the CFO of Blackwell Automotive, Inc., is putting together this year's financial statements. He has gathered the following balance sheet information: The firm had a cash balance of $23,015, accounts payable of $163,257, common stock of $313,299, retained earnings of $512,159, inventory of $212,444, goodwill and other assets equal to $78,656, net plant and equipment of $711,256, and short-term notes payable of $21,115. It also had accounts receivable of $141,258 and other current assets of $11,223. How much long-term debt does Blackwell Automotive have?

19. [EXCEL] Working capital: Mukhopadhya Network Associates has a current ratio of 1.60, where the current ratio is defined as follows: . The firm's current assets are equal to $1,233,265, its accounts payables are $419,357, and its notes payables are $351,663. Its inventory is currently at $721,599. The company plans to raise funds in the short-term debt market and invest the entire amount in additional inventory. How much can notes payable increase without the current ratio falling below 1.50?

20. [EXCEL] Market value: Reservoir Bottling Company reported the following information at the end of the year. Total current assets are worth $237,513 at book value and $219,344 at market value. In addition, plant and equipment have a market value of $343,222 and a book value of $362,145. The company's total current liabilities are valued at market for $134,889 and have a book value of $129,175. Both the book value and the market value of long-term debt are $144,000. If the company's total assets have a market value of $562,566 and a book value of $599,658, what is the difference between the book value and market value of its stockholders' equity?

21. [EXCEL] Income statement: Nimitz Rental Company provided the following information to its auditors. For the year ended March 31, 2017, the company had revenues of $878,412, general and administrative expenses of $352,666, depreciation expenses of $131,455, leasing expenses of $108,195, and interest expenses equal to $78,122. If the company's average tax rate is 34 percent, what is its net income after taxes?

26. [EXCEL] What is the cash flow for Nimitz Rental?

Answer 1

Compute cash flow invested in long-term assets by Del Bridge during 2017 as follows: Long-term assets before depreciation on December 31, 2017 Less: Long-term assets before depreciation on December 31, 2016 Cash flow $1.211.105 ($990,560) S220,545 18.

Balance sheet Cash Invertory Accounts receivable Other current assets Total Current assets (A) $23,015 $212,444 $141,258 $11,223 S387,940 Plant and equipment, net Goodwill and other assets Total noncurrent assets (B) $711,256 $78,656 $789,912 Total Assets (A+B) s1.177,852 Liabilities: Current liabilities Accounts payable Short-term note payable Total current liabilities $163.257 $21,115 $184,372 Total long-term debt (Balancing figure) ($1177852-5825458-S184372] $168,022 Common stock Retained earnings Total stockholders' equity $313.299 $512,159 S825.458 Total Liabilities and stockholders' equity $1,177,852

21. Compute Net income after tax as follows: $878,412 Revenues Less: Expenses: General and Administrative expense Depreciation expense Leasing expense Interest expense Income before taxes Tax ($207974 x 34%) Net income after tax $352,666 $131.455 $108.195 $78,122 $670.438 $207,974 ($70,711.16) $137.262.84 17 Exhibit 3.6 is missing for tax rates.