Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Accounting questions