Pro forma balance sheet, income statement, and ratios
Not what you're looking for?
I need assistance formulating pro forma financial documents and calculating NPV IRR and payback periods please provide instruction using Microsoft Excel.
1)Given the information below, utilize the percent of sales method to prepare a pro forma balance sheet, income statement, and selected ratios.
1.Sales will increase by 25% next year.
2.The following balance sheet items will increase in direct relation to sales:
a.Cash
b.Accounts Receivable
c.Inventory
d.Fixed Assets
e.Accounts Payable
3.Management forecasts that Notes payable will need to increase by $1,000,000 to support the increase in sales.
4.Management forecasts that Earnings after Taxes will be $2,750,000 next year.
5.The company intends to pay the same amount of dividends next year.
See attachment
2)Stephen Company currently has two mutually exclusive projects under consideration:
Year Project A Project B
0 -30,000 -60,000
1 10,000 20,000
2 10,000 20,000
3 10,000 20,000
4 10,000 20,000
5 10,000 20,000
1. Calculate the following values for each project using the time value tables: (Assume a 14%
discount rate)
? NPV
? IRR
? Payback period
2. Which project would you choose? Why would you choose it?
Purchase this Solution
Solution Summary
The solution explains how to prepare proforma financial statements and calculate ratios
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
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.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media