Discounted Cash Flow Valuation - Calculating Equity Value Knowing how to perform an unlevered DCF and calculate equity value is an essential skill for a world-class analyst. Open the attached Excel file found above the question and go to the worksheet labeled: Equity Value (Blank) Calculate the company’s equity value at the end of Year 0 given the information in the Excel file. Assume end-of-period-discounting.$205,421$184,478$228,316$164,382

Discounted cash flows applicationsNet present Value calculations have a broad range of applications in finance.Calculate the NPV of the project based on the information below.Initial investment: $20,000Cash flow generated each year: $5,000Total period: 5 YearsDiscount rate: 6%$2108.75$3,669.52$875.43$1,061.82

Using the financial statements below, calculate the Return on equity for the current year. Please calculate to 2 decimal places. Do not use the % symbol. For example, if it is 3.2%, enter 3.2 into the box. If the number is negative, remember to add a minus symbol before the number Profit and loss statement Current year Prior year Revenue 14,800 18,500 Less Cost of sales 6,000 7,500 Gross profit 8,800 11,000 Less expenses Wages Expense 5,500 6,500 Interest Expense 2,200 2,000 Depreciation Expense 1,000 1,200 Advertising Expense 900 800 Net profit (800) 500 BALANCE SHEET Current year Prior year Current assets Cash 14,250 16,700 Accounts Receivable 14,000 3,500 Inventory 6,000 2,500 Prepaid Expenses 650 1,500 Non-current assets Property Plant Equipment 192,500 193,500 Land 210,000 210,000 Total assets 437,400 427,700 Current liabilities Accounts Payable 11,700 4,200 Unearned Revenue 3,500 2,000 Wages Payable 3,500 2,500 Non-current liabilities Bank Loan 118,000 122,500 Total liabilities 136,700 131,200 NET ASSETS 300,700 296,500 Equity Share Capital 255,000 250,000 Retained Earnings 45,700 46,500 TOTAL EQUITY 300,700 296,500

Using the financial statements below, calculate the debt to equity ratio for the current year. Please calculate to 2 decimal places.Profit and loss statement Current year Prior yearRevenue 14,800 18,500Less Cost of sales 6,000 7,500Gross profit 8,800 11,000Less expenses Wages Expense 5,500 6,500Interest Expense 2,200 2,000Depreciation Expense 1,000 1,200Advertising Expense 900 800Net profit (800) 500BALANCE SHEET Current year Prior yearCurrent assets Cash 14,250 16,700Accounts Receivable 14,000 3,500Inventory 6,000 2,500Prepaid Expenses 650 1,500Non-current assetsProperty Plant Equipment 192,500 193,500Land 210,000 210,000Total assets 437,400 427,700Current liabilitiesAccounts Payable 11,700 4,200Unearned Revenue 3,500 2,000Wages Payable 3,500 2,500Non-current liabilitiesBank Loan 118,000 122,500Total liabilities 136,700 131,200NET ASSETS 300,700 296,500Equity Share Capital 255,000 250,000Retained Earnings 45,700 46,500TOTAL EQUITY 300,700 296,500

You are evaluating a project with cash flows of ₹1,200 in the first year, ₹900 in the second year, and ₹1,500 in the third year. If the discount rate is 12%, what is the present value of these cash flows?

You've been provided with the following information about a businessComplete a VERTICAL analysis for the "Cash" account for the current year. Round the percentage to one decimal place.Note: Do not enter the "%" symbol when entering your answer. For example if your answer is "5.1%", only enter "5.1". If your answer is negative - remember to include the minus.Balance sheet Current year Prior yearCurrent Assets Cash 14,250 16,700Accounts Receivable 14,000 3,500Inventory 6,000 2,500Prepaid Expenses 650 1,500Non-current assetsProperty Plant Equipment 192,500 193,500Land 210,000 210,000TOTAL ASSETS 437,400 427,700Current liabilitiesAccounts Payable 11,700 4,200Unearned Revenue 3,500 2,000Wages Payable 3,500 2,500Non-current liabilitiesBank Loan 118,000 122,500TOTAL LIABILITIES 136,700 131,200NET ASSETS 300,700 296,500Equity Share Capital 255,000 250,000Retained Earnings 45,700 46,500TOTAL EQUITY 300,700 296,500