Attachment # 00005782 - MT480_u3_team_worksheets_(2).xlsx
MT480_u3_team_worksheets_(2).xlsx (41.1 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Complete the 2014 Cash Flow StatementA. Calculate the net cash provided by operating activities for the statement of cash flows.B. What is the net cash used in investing activities?C. Compute the net cash used by financing activities.Bob Smith Inc.Statement of Cash Flows December 31, 2014You need to figure cash flows for:OPERATING ACTIVITIESAccounts receivableNet incomeInventoryAdditions (Sources of Cash)Property- plant and equipmentDepreciation and amortizationLong-term debtIncrease in accounts payableDecrease in accounts receivableYour WorkIncrease in accrued income taxesSubtractions (Uses of Cash)Increase in other current assetsIncrease in inventoryYour WorkNet cash: Operating activitiesA. SubTotalLONG-TERM INVESTING ACTIVITIESIncrease in property and equipmentYour WorkDecrease in goodwill and other assetsAAANet cash: Long Term Investing activitiesMT 480 Case Study Bob Smith Loan Review Data for TeamsB.Sub TotalStatement of Cash Flows YE 2011Statement of Cash Flows Worksheet December 31, 2014FINANCING ACTIVITIESIncrease in notes payableDecrease in long-term debtYour WorkPayment of cash dividendsPurchase of treasury stockNet cash: Financing activitiesASSETSCash Up or DownCash and marketable securities$$Not NeededAccounts receivable$$Inventory$$Other current assets$C. Sub TotalCash and securities at the beginning of the yearNet Cash from Above: Net Income , Depreciation, A B, & C$Total current assets$Total = Proof$Not NeededPlant and equipmentCash and securities at the end of the year2011 Cash-$$Less: Accumulated depreciation$$Not NeededNet plant and equipment$$Goodwill and other assets$$Not NeededTotal Assets$$Not NeededLIABILITIES AND EQUITYAccounts payable and accruals$$Notes payable$$Accrued income taxes$$Total current liabilities$$Not NeededLong-term debt$$Total liabilities$$Not NeededPreferred stock$$Common stock (10,000 shares)$$Additional paid in capital$$Retained earnings$$Not NeededLess: Treasury stock$$Total common equity$$Total Liabilities and Equity$$Not NeededIn addition, it was reported that the company had a net income of $3,155,848 and depreciation expenses were equal to $212,366 during 2014.Net IncomeDepreciationDividends Paid
Mt480 team assignment

Mt480 team assignment

Question # 00072147 Posted By: neil2103 Updated on: 05/22/2015 05:28 AM Due on: 05/31/2015
Subject Finance Topic Finance Tutorials:
Question
Dot Image
The Cash flow statement needs to be completed and a business letter with values in it has to be written

With denial and why.

Team Assignment Instructions The Team Assignment requires an analysis of specific financial data of Bob Smith Inc. Bob is an existing bank customer.

When the loan to Bob was originally made in 2013 the bank required Bob to increase the YE 2014 cash balance to at least $70,000. The Cash Flow

Statement and Balance Sheet show an actual YE 2014 cash balance of less than

$34,000. The Team Assignment requires participation in a team effort to

complete the (partially prepared) 2014 Cash Flow Statement. In Seminar 1 you

discussed how to complete and use the 2014 Cash Flow Statement outcomes to

explain how specific accounts influenced Bob's low cash balances.in other

words.some reasons why Bob has no cash! This information allows you to

substantiate the 2015 loan denial. You are aware this action will create

dire financial circumstances for Bob's company. As the loan officer you

Units 1-3 [MT480: Corporate Finance] must pass along the news in a business

letter that is most professional and written in an objective manner. Please

use values in the letter whenever possible. The documents for this project

will be reviewed in Seminar 1 and the Team Assignment will be due by the end

of Unit 3.

Requirements This project includes data for the a) comparative Balance

Sheets, b) partially completed Cash Flow Statement worksheet and, c) the

template outline of the loan denial letter. Each document will be reviewed

in the Week 1 Seminar. You will locate the comparative Balance Sheets and

Cash Flow Statement worksheet in

Dot Image
Attachments
MT480_u3_team_worksheets_(2).xlsx (41.1 KB)
Tutorials for this Question
  1. neil2103
    Tutorial # 00066814 Posted By: neil2103 Posted on: 05/22/2015 05:29 AM
    Puchased By: 6
    Tutorial Preview
    The solution of Mt480 team assignment...
      Get the Solution
    Attachments
    MT480_u3_team_worksheets__2___.xlsx (40.16 KB)
    MT480_u3teamoutline__1_1_.doc (50 KB)
Whatsapp Lisa