Purchase Solution

Pro forma capital budget

Not what you're looking for?

Ask Custom Question

I have the data needed to complete the pro forma capital budget, I just cant figure out how to do it. This is using part 1 of answers provided from a previous question (I will attach). Any help would be appreciated.

The NPV.xls has the data needed to complete the problem.
The pro forma budget.xls is the sheet in which the answers need to be placed.

The answer is probably on the site someplace I just have'nt been able to find it. Any help would be really appreciated.

Thanks

Attachments
Purchase this Solution
Solution Summary

The solution explains how to prepare a pro forma capital budget.

Solution Preview

Please see the attachment. What has been done is
In the NPV file we are directly given the after tax cash flows as labor savings, while in the capital budget file we need to break ...

Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

View More Free Quizzes
Related BrainMass Solutions

  • Working Capital, Pro Forma financial statement and Forecasts

    In addition, discuss how the cash budget and capital budget relate to pro forma financial statement preparation.

  • How financial executives use pro forma financial statements

    Besides the pro-forma financial statements, evaluations would best be made with accompanying documents including: 1. A cash flow budget 2. A sales budget 3. A financing plan for short term debt 4. A capital budget for major purchases 5.

  • Are Pro Forma Statements part of financial analysis?

    Besides the pro-forma financial statements, decisions would best be made with accompanying documents including: 1. A cash flow budget 2. A sales budget 3. A financing plan for short term debt 4. A capital budget for major purchases 5.

  • Cash budget

    What are the risks associated with inaccuracies in preparing the pro forma income statement and cash budget?

  • Planning Process, Forecast, Budgeting, Projection, Cash

    A pro forma 3.

  • Depreciation of Assets in the Next Planning Period

    The statements that will be directly affected immediately are the _______ (a) pro forma income statement, pro forma balance sheet, & cash budget (b) pro forma balance sheet, cash budget, & statement of retained earnings (c) cash budget &

  • Managerial accounting - budgeting

    , compliance efforts, and administrative functions of the business) | | V Capital Budget (projects to be funded given the cash or capital capacity and the viable projects identified by the decision-makers) | | V Forecasted (Pro-forma)

  • Pro-forma financial statements

    Pro-forma financial statements include an income statement, a balance sheet, and a statement of cash flows. b. The pro-forma financial statements complete the master budget for a company. c.

  • Master Budget and Financial Statements

    Prepare a cash budget. h. Prepare a pro forma income statement for the quarter. i. Prepare a pro forma balance sheet at the end of the quarter. j. Prepare a pro forma statement of cash flows for the quarter. Please see the attachment.

View More Related Solutions