Purchase Solution

Creating a Statement of Cashflows

Not what you're looking for?

Ask Custom Question

1. In Module 3, you will take your income statements and start to construct a cash flow

2 .Using the income statement from Assignment 1, forecast a ten year cash flow using the following assumptions: from 2010-2019

Capital Expenditures of $50,000 per year.
Leasehold Improvements of $10,000 per year.
DSO of 75 Days.
Inventory Turnover of 12 times.
Accounts Payable of 30 days.
Depreciation is constant.
The combined Federal and State Tax Rate is 40%.
There are no additional financing expenses associated with the transaction.
After you have completed your cash flow forecast, calculate a Net Present Value assuming a discount rate of 15%.

Purchase this Solution

Solution Summary

How to create a statement of cash flows from income statement

Solution Preview

Please see attached Excel file and pay special attention to the comments I made.

NOTE: I made two cash flows. The other one is with the formulas you provided. ...

Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Basics of corporate finance

These questions will test you on your knowledge of finance.

Motivation

This tests some key elements of major motivation theories.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.