Attachment # 00010689 - Module_2_-_Homework_Assignment_Template.xlsx
Module_2_-_Homework_Assignment_Template.xlsx (20.75 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Solution LegendValue given in problemFormula/Calculation/Analysis requiredQualitative analysis or Short answer requiredFinancial DataAssetsCash & Short Term InvestmentsShort-term InvestmentsReceivablesInventoriesPrepaid ExpensesTotal Current AssetsNet Property, Plant & EquipmentTotal AssetsLiabilitiesAccounts payableCurrent maturities of long-term debtIncome taxes payableTotal current liabilitiesLong-term debtTotal LiabilitiesTotal stockholders’ equity (deficit) Total Liabilities & Shareholder's EquityIncome StatementRevenueTotal revenuesExpensesCost of Goods SoldGeneral, administrative and otherDepreciation and amortizationTotal expensesOperating incomeInterest expenseIncome before income taxesIncome tax benefit (expense)Net incomeDividends PaidNon-distributed IncomeFind Changes in NWCCurrent Assets, other than Cash and Marketable SecuritiesCurrent Liabilities, excluding DebtNet Working Capital (CA-CL)Change in NWC (NWC Investment)Find CapExCapexYou can read more using the following linkHoward Keen, Clearing Up Confusion over calculation of FCF.Estimate FCFYearEBIT Plus: Depreciation ExpenseLess: CAPEXLess: Working Capital InvestmentFirm Free Cash FlowEBIT(1-T) = NOPATTax Rate
finance questions excel

finance questions excel

Question # 00494831 Posted By: walt1978 Updated on: 03/03/2017 07:11 PM Due on: 03/05/2017
Subject Finance Topic Finance Tutorials:
Question
Dot Image

Based on historical financial data, find FCF for the company of your choice.

  1. Please use excel for the Lockheed Martin company

  2. Download annual financial data for the last 5 years from Edgar Website (forms 10-K).

  3. Using approach similar to the one described in this module's Excel file you will have to calculate the FCF for the company of your choice. I suggest starting from the FS to FCF Practice Template and adjust it accordingly

Dot Image
Attachments
Module_2_-_Homework_Assignment_Template.xlsx (20.75 KB)
Tutorials for this Question
  1. neil2103
    Tutorial # 00491346 Posted By: neil2103 Posted on: 03/03/2017 07:50 PM
    Puchased By: 3
    Tutorial Preview
    The solution of finance questions excel...
      Get the Solution
    Attachments
    Module_2_-_Homework_Assignment_Template-sol.xlsx (21.29 KB)
Whatsapp Lisa