Purchase Solution

Preparation of 4 Financial Statements

Not what you're looking for?

Ask Custom Question

There is NO OTHER information provided for the assignment. You are supposed to make up the 4 statements for an imaginary business. Therefore, please feel free to make up any numbers other than for those provided.

Need pro forma financials - 4 STATEMENTS

1) Pro forma sales - 3 years - based on 1 sale each year supplemented by consultancy fees.
Revenue year 1 - based on 1 shipment (software) - $110,000
Year 2 shipment - 1 shipment - 20% over year 1
Year 3 shipment - 1 shipment - 20% over year 2
Consultancy - year 1 $110,000
Year 2 - 20% over year 1
Year 3 - 20% over year 2

2) Projected Income Statement - based on above sales/consultancy fees for
year 1, year 2, year 3
Costs for each year would include:
Salaries
Office lease
Materials
Admin Expenses
Marketing
Taxes
Debt financing for year 1 start up loan of $220,000 @ 6% annual interest
Plus any other reasonable cost items

3) Pro forma balance sheets based on all above assumptions etc.
year 1, year 2, year 3

4) Pro forma cash flow (break even analysis) statements - year 1, year 2, year 3.

PLEASE MAKE ANY NECESSARY ASSUMPTIONS FOR THIS Information Technology CONSULTANCY business.

Purchase this Solution

Solution Summary

Excel spreadsheets with easy to understand methods of constructing financial statements for imaginary companies included.

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Basics of corporate finance

These questions will test you on your knowledge of finance.

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.

Basic Social Media Concepts

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