Question
Project Costing and Cash Flow Modelling For the following project, calculate the undiscounted cash flow. You...
Project Costing and Cash Flow Modelling
For the following project, calculate the undiscounted cash flow. You can do it in Excel and paste the result below:
|
Year |
0 |
1 |
2 |
3 |
4 |
5 |
|
Unit Price |
- |
$105 |
$110 |
$115 |
$120 |
$125 |
|
Units Sold |
- |
900 |
1000 |
1100 |
1200 |
1300 |
|
Net Sales |
- |
|||||
|
Variable Costs |
- |
$54,000 |
$60,000 |
$66,000 |
$72,000 |
$78,000 |
|
Fixed Costs |
- |
$15,000 |
$15,750 |
$16,538 |
$17,364 |
$18,233 |
|
Depreciation |
- |
$10,000 |
$10,000 |
$10,000 |
$10,000 |
$10,000 |
|
PBIT |
- |
|||||
|
Tax@40% |
- |
|||||
|
NOPAT |
- |
|
||||||||||||||||||||||||||||||||||||||||||
Place your answer (Excel) in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above.
Homework Answers
Answer #1
In case of any doubts or Issues, please comment below
Not the answer you're looking for?
Similar Questions
3.1 Project Costing and Cash Flow Modelling For the following project, calculate the undiscounted cash flow....
3.1 Project Costing and Cash Flow Modelling For the following
project, calculate the undiscounted cash flow. You can do it in
Excel and paste the result below.
Year
0
1
2
3
4
5
Unit Price
-
$105
$110
$115
$120
$125
Units Sold
-
900
1000
1100
1200
1300
Net Sales
-
Variable Costs
-
$54,000
$60,000
$66,000
$72,000
$78,000
Fixed Costs
-
$15,000
$15,750
$16,538
$17,364
$18,233
Depreciation
-
$10,000
$10,000
$10,000
$10,000
$10,000
PBIT
-
Tax@40%
-...
Given the following project information, calculate the after-tax operating cash flow (ATOCF) using the four approaches...
Given the following project
information, calculate the after-tax operating cash flow (ATOCF)
using the four approaches of calculating operating cash flow.
Project cost = $950,000
Project life = five years
Projected number of units sold per
year = 10,000
Projected price per unit = $200
Projected variable cost per unit =
150
Fixed costs per year = $150,000
Required rate of return = 15%
Marginal tax rate = 35%
Depreciation = Straight-line to zero
over five years (ignore...
You have the following investment options as laid out in the table below: Project Cash Flow...
You have the following investment options as laid out in the
table below:
Project Cash Flow
Year
A
B
C
D
E
0
-$1000
-$1200
-$2000
-$1600
-$1400
1
900
800
950
900
400
2
500
700
950
900
400
3
100
700
950
900
1200
4
50
300
950
900
400
If your MARR is 15%, which of these options should you select?
Solve this problem by challenger-defender
analysis.
A project has the following cash flow. Year Costs Benefits 0 $10,000 0 1 $1,000 $5,000...
A project has the following cash flow.
Year
Costs
Benefits
0
$10,000
0
1
$1,000
$5,000
2
$1,000
$5,000
3
$2,000
$6,000
4
$2,0000
$3,000
Assuming a discount rate of 10%, estimate the following:
a)Net Present Value (NPV)
b)Discounted Benefit-Cost Ratio
c)Net discounted Benefit-Cost Ratio
d)Is the project feasible? Explain your answer
Fill in the spreadsheet below with the appropriate cell formulas to compute the operating cash flow,...
Fill in the spreadsheet below with the appropriate cell
formulas to compute the operating cash flow, for example the
formula is provided for the fixed costs in cell B12. (Do
not put in the numerical answers, just the Excel cell
formulas)
B
C
D
E
1
2
Assumptions
3
Price
$10
4
Quantity
100,000
5
Fixed Costs
25,000
6
VC Percent
65%
7
Tax Rate
30%
8
Depreciation
10,000
9
10
Sales Revenue
(a)
11
Variable Costs
(b)
12
Fixed...
Income and Cash Flow Analysis The Berndt Corporation expects to have sales of $13 million. Costs...
Income and Cash Flow Analysis
The Berndt Corporation expects to have
sales of $13 million. Costs other than depreciation are expected to
be 80% of sales, and depreciation is expected to be $1.3 million.
All sales revenues will be collected in cash, and costs other than
depreciation must be paid for during the year. Brendt's
federal-plus-state tax rate is 35%. Berndt has no debt. The data
has been collected in the Microsoft Excel Online file below. Open
the spreadsheet and...
1. Project Cash Flow The financial staff of Cairn Communications has identified the following information for...
1. Project Cash Flow
The financial staff of Cairn Communications has identified the
following information for the first year of the roll-out of its new
proposed service:
Projected sales
$24 million
Operating costs (not including
depreciation)
$7 million
Depreciation
$6 million
Interest expense
$5 million
The company faces a 40% tax rate. What is the project's
operating cash flow for the first year (t = 1)? Enter your answer
in dollars. For example, an answer of $1.2 million should be...
Use the following information from Cersie Company to create the Cash Flow from Operations Section of...
Use the following information from Cersie Company to create the
Cash Flow from Operations Section of the Cash Flow Statement using
the indirect method. Note: You may not have sufficient information
to prepare a complete cash flow statement but you do have enough to
do just the Cash Flow from Operations section.
Cersei Company
Income Statement
For the Year Ended December 31, 2019
Net Sales Revenue
$325,000
Cost of Goods Sold
222,000
Gross Profit
$103,000
Operating Expenses:
Selling Expenses
Commission...
1. Newex, Inc. has a capital investment opportunity with the following cash flows: Year cash flow...
1. Newex, Inc. has a capital investment opportunity with the
following cash flows:
Year cash flow
0 (100,000)
1 45,000
2 35,000
3 30,000
4 20,000
Which of the following is closest to the project’s payback
period?
a) 4 years
b) 2 years
c) 3.7 years
d) 3.5 years
e) 2.7 years
2. Zoomit Corporation has a capital investment opportunity that
will cost $250,000. The cash inflows from year 1 through year 10
will be $40,000 each year. The firm’s...
Course Project Week 4 For this next part of the project you will build the Income...
Course Project Week 4
For this next part of the project you will build the Income
Statement and Balance Sheet for the Bike Repair & Maintenance
Shop (BRMS) for 2018. Use the information below and add another
sheet to your Excel Workbook.
BRMS Information for 2018
In 2017, the repair shop was opened in October and ended the
year with a ($10,500) operating loss.
Supply Inventory of parts & supplies maintained
$3,000
Replacement parts are ordered as they are used....
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 1 minute ago
asked 29 minutes ago
asked 37 minutes ago
asked 44 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago