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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started