Make a pro forma cash flow You have been asked to evaluate the financial viability of a
Fantastic news! We've Found the answer you've been seeking!
Question:
Make a pro forma cash flow
Transcribed Image Text:
You have been asked to evaluate the financial viability of a mining project. Here is the relevant information about the investment plan for the project: There is an Excel sheet with a template on Blackboard. Year o Investment Plan Site Preparation Materials, imported, net of tax Tariffs at 15% Sales tax at 5% Skilled labor Ec 421: Public Finance Unskilled labor Equipment Imported, net of tax Tariffs at 15% Sales tax at 5% Land = Total Investment Expenditure Financing Government equity (including grant of land) Government: short-term loan Foreign loan, guaranteed by foreign government Purchases Material inputs Local Sales tax at 596 Imported Tariffs at 15% Sales tax at 596 150 Assignment 4 [4 hours] Skilled labor 400 60 20 250 Here is the operating plan for the mine, which will only work for three years. Operating Plan Year o 1 Sales 2,000 O O 20 600 90 30 100 1,700 850 150 700 200 10 600 90 30 100 50 500 2 2,800 500 100 30 240 12 700 105 35 100 50 425 2 900 150 45 3 2,800 240 12 700 105 35 100 Unskilled labor Other: depreciation Working capital (end of period) Accounts receivable Accounts payable Cash on hand Use the parameter tables above to create a pro forma cash flow. [A spreadsheet file with these numbers may be 50 375 3 800 140 40 4 4 400 Page 1 of 2 0 0 You have been asked to evaluate the financial viability of a mining project. Here is the relevant information about the investment plan for the project: There is an Excel sheet with a template on Blackboard. Year o Investment Plan Site Preparation Materials, imported, net of tax Tariffs at 15% Sales tax at 5% Skilled labor Ec 421: Public Finance Unskilled labor Equipment Imported, net of tax Tariffs at 15% Sales tax at 5% Land = Total Investment Expenditure Financing Government equity (including grant of land) Government: short-term loan Foreign loan, guaranteed by foreign government Purchases Material inputs Local Sales tax at 596 Imported Tariffs at 15% Sales tax at 596 150 Assignment 4 [4 hours] Skilled labor 400 60 20 250 Here is the operating plan for the mine, which will only work for three years. Operating Plan Year o 1 Sales 2,000 O O 20 600 90 30 100 1,700 850 150 700 200 10 600 90 30 100 50 500 2 2,800 500 100 30 240 12 700 105 35 100 50 425 2 900 150 45 3 2,800 240 12 700 105 35 100 Unskilled labor Other: depreciation Working capital (end of period) Accounts receivable Accounts payable Cash on hand Use the parameter tables above to create a pro forma cash flow. [A spreadsheet file with these numbers may be 50 375 3 800 140 40 4 4 400 Page 1 of 2 0 0
Expert Answer:
Answer rating: 100% (QA)
Year1234 Cash Flow Initial Investment2800 Operating Cash Flow Sales200028002800 Cost of Goods Sold28... View the full answer
Related Book For
Managing Supply Chain and Operations An Integrative Approach
ISBN: 978-0132832403
1st edition
Authors: Thomas Foster, Scott E. Sampson, Cynthia Wallin, Scott W Webb
Posted Date:
Students also viewed these finance questions
-
You have been asked to evaluate the monthly stock price growth for a portfolio which contains the following firms: 3M Company, Alcoa, Inc., Intel Corporation, Potlatch Corp., General Motors, and Sea...
-
You have been asked to evaluate the cost-to-cost trade-offs for the following situation: Diesel fuel cost of $5.00 per gallon Distance to be covered = 900 miles Miles per gallon at 75 mph = 6 Miles...
-
You have been asked to evaluate the attractiveness of a group of identified potential market segments. What criteria will you use to evaluate those segments? Why are these appropriate criteria?
-
Considering all of the below, recommend and justify a price for this deal. This is not easy to do. Put yourself in the shoes of the Robertson managers. Who wants it more? The buyer-Monmouth? The...
-
The scandal on backdating stock options introduced new terminology to describe these controversial practices. Describe what you think each of these terms means. a. Backdating b. Repricing c....
-
Consider steady, two-dimensional, incompressible flow due to a spiraling line vortex/sink flow centered on the z-axis. Streamlines and velocity components are shown in Fig. P989. The velocity field...
-
According to a survey, the probability that an adult chosen at random watches a movie every day is about 0.60. Classify the statement as an example of classical probability, empirical probability, or...
-
The A&Z Real Estate Co. is to be liquidated. The book value of its assets is $52 billion. Bonds with a face value of $28 billion are secured by a mortgage on the companys Toronto and New York...
-
A venturi meter is used for measuring flow of water along a pipe.The diameter of the Venturi throat is two fifths the diameter of the pipe.The inlet and throat are connected by water filled tubes to...
-
After the dot-com business he tried to start folded, David "Marty" Dawkins decided to pursue his boyhood dream of owning a bike factory. After several false starts, he finally got the small company...
-
FOR 2023 Starplus Limited is well known for its focus on customer satisfaction and this is highlighted in the company profile. Their About Us page on their website tells a story of service and...
-
Outline the Early Years Learning Framework (EYLF) principles and the Learning Outcomes that reflect a commitment to inclusion.
-
A 3 . 5 - kg mass weighs 3 5 N and is held 6 . 8 m above the ground. Calculate its potential energy relative to the ground. Round to the whole Joule. A student lifts a 1 . 2 k g bag from her desk,...
-
What are the ways in which racism might affect your view of bullfighting
-
Consider the effect of collusion between bidders in a second- price, sealed- bid auction. There is one seller who will sell one object using a second-price sealed-bid auction. The bidders have...
-
Most organizations of varying sizes tend to emphasize market-competitive pay systems . What do you believe is most important for a company's competitive advantage with people by way of compensation...
-
a) Two different strains of cold virus were isolated and put in cultures to grow. Virus A triples every' 8 h while virus B doubles every 4.8 h. If each culture has 1000 viruses to start, which has...
-
In Exercises 1558, find each product. (9 - 5x) 2
-
A company wants to develop a simple linear regression model for one of its products. Use the following 12 periods of historical data to develop the regression equation and use it to forecast the next...
-
What actions can be taken to reduce derived demand?
-
Briefly define and describe how a process-chain-network (PCN) diagram can be used in designing service delivery systems.
-
With a neat sketch of a room air-conditioner, explain its working principle.
-
Distinguish between a heat engine, a heat pump, and a refrigerator.
-
Discuss about psychrometry and their properties?
Study smarter with the SolutionInn App