Question

In: Finance

Assignment You are a consultant, external to this firm. Create two years (2020 and 2021) of...

Assignment

You are a consultant, external to this firm. Create two years (2020 and 2021) of pro forma income statements and balance sheets and the statement of cash flows, including operating, investing and financing sections for 2020 only.

Techno Corporation

Techno Corp

Income Statement

Actual results 2019 for 12 months ending December 31, 2019

Sales revenue (10,000 units at $250 each) $2,500,000
Cost of goods sold ($100 per unit) ($1,000,000)
Gross profit $1,500,000
Operating expenses ($500,000)
Operating profit $1,000,000
Interest expense ($200,000)
Net profits before taxes $800,000
Taxes (30%) ($240,000)
Net profits after tax $560,000
Dividends on common stock $224,000

Techno Corp

Balance Sheet

December 31, 2019

ASSETS $500,000
Marketable securities $300,000
Accounts receivable $500.000
Inventory $400,000
Total current assets $1,700,000
Net fixed assets $2,000,000
Total assets $3,700,000
LIABILITIES AND STOCKHOLDER’S EQUITY
Accounts payable $150,000
Taxes payable $120,000
Notes payable (long-term debt due within one year) $200,000
Other current liabilities $200,000
Total current liabilities $670,000
Long-term debt $1,800,000
Total liabilities $2,470,000
Common stock $500,000
Retained earnings $730,000
Total liabilities and stockholder’s equity $3,700,000

Techno Corporation Paper

Techno Corporation is developing its pro forma financial statement forecasts for 2020 and 2021. Its actual results for 2019 are shown in the income statement and balance sheet.

Background

  • The relationship between cost of goods sold and sales revenue Is expected to continue in the near term and no inflation is expected.
  • Operating expenses include $200,000 in depreciation (fixed expense), the remainder is variable costs tied to sales revenue.
  • Fixed assets are adequate to support sales growth for the next two years and long=term debt will decline $200,000 per year.
  • Dividend policy calls for 40% of net profits after taxes to be paid before yearend.
  • Interest is 10% of long-term debt and notes payable
  • Inventory needs to grow at half the rate of sales growth and accounts receivable maintains the same relationship to sales as was the case on December 31, 2019 for 2019 sales. Accounts payable maintains the same relationship to cost of good sold as of December 31, 2019 for 2019 sales.
  • Any cash over $500,000 is put in marketable securities, Interest income is negligible
  • Other current liabilities are stable.
  • Taxes payable are equal to one-half of the current year’s taxes.
  • Assume sales will increase 10% per year for each of the next two years.

Solutions

Expert Solution

Note:

1. It is assumed that "Asset" includes cash, and thus the cash used during the year is reduced from Assets in balance sheet.

2. No investment in marketable securities have been done during the year as the cash is not in excess of $500000.

3. All the amounts are in $.

4. Amount of Tax Payable is half of current year tax payable, assuming the balance is paid in cash as advance tax.

5. Rate of Tax is assumed to be same as of previous year.


Related Solutions

For this assignment you are required to create two loan amortization schedules. However, after you create...
For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. Your directions are as follows: Create a loan amortization schedule using Excel for a $36,000 car loan that will be repaid over 60 months at an annual interest rate of 4.5%. What is your monthly payment? What is the total amount you have paid over the life...
a)You are an external consultant, and providing consultancy services to VanServ Inc.. Below you will see...
a)You are an external consultant, and providing consultancy services to VanServ Inc.. Below you will see some financial information for 2019. The owner of the company asked you to prepare a contribution income statement. b) Manager of the company has also a bonus plan (2% of the controllable contribution margin for the year is to be paid as yearly bonus). You are also asked to calculate the bonus. The contract of the manager will be renewed next year, so the...
you are hired as the consultant to a monopolistically competitive firm
you are hired as the consultant to a monopolistically competitive firm. The firm reports the following information about its price, marginal cost, and average total cost. Can the firm possibly be maximizing profit? If the firm is profit maximizing, is the firm in a long-run equilibrium? If not, what will happen to restore long-run equilibrium? a. P < MC, P > ATC I would think that the firm can’t possible be maximizing profit. The firm should raise price, so that...
You are hired as a consultant to a monopolistically competitive firm. The firm reports the following...
You are hired as a consultant to a monopolistically competitive firm. The firm reports the following information about its price, marginal cost, and average total cost: P = MC, P> ATC Which of the following statements is true about the firm? Check all that apply. The firm can increase its profit by reducing its output. The firm is in long-run equilibrium. The firm is possibly maximizing profit.
A firm has hired you as a consultant. This firm is perfectly competitive and has no...
A firm has hired you as a consultant. This firm is perfectly competitive and has no control over price. This firm is selling 10,000 units at a price of $3. Total costs are $40,000. Total variable costs are $35,000. They can produce another unit at a cost of about $3. What do you recommend? shut down continue to operate at a loss in the short run decrease quantity increase quantity
Question 2. Suppose you are a consultant for a firm that is perfectly competitive. The firm...
Question 2. Suppose you are a consultant for a firm that is perfectly competitive. The firm is worried only about its policies in the short run. What would you recommend in terms of quantity changes (raise, cut, shut down or stay put) and price changes (raise, cut, stay put) in each of the following situations: a. [15 points] P $19 MC $14 AVC $20 b. [15 points] P S11MC S106 AVC $107 Notations/Abbreviations: P- price; MC-marginal cost; AVC- average variable...
C++ Assignment 1: Make two classes practice For each of the two classes you will create...
C++ Assignment 1: Make two classes practice For each of the two classes you will create for this assignment, create an *.h and *.cpp file that contains the class definition and the member functions. You will also have a main file 'main.cpp' that obviously contains the main() function, and will instantiate the objects and test them. Class #1 Ideas for class one are WebSite, Shoes, Beer, Book, Song, Movie, TVShow, Computer, Bike, VideoGame, Car, etc Take your chosen class from...
Requirements: In this assignment, you are going to create two switch functions. The first function is...
Requirements: In this assignment, you are going to create two switch functions. The first function is going to be called switchVal and the second is going to be called switchRef. The goal of this assignment is to demonstrate the understanding of what pass-by-reference (Links to an external site.) and pass-by-value (Links to an external site.) do when working with functions that you create. The two functions that you will modify need to accept two parameters and inside them they need...
Assignment 5: Roman Numerals Assignment 5 You must create an application that takes two integer values,...
Assignment 5: Roman Numerals Assignment 5 You must create an application that takes two integer values, adds them together, and then displays the result of that expression as a roman numeral. Create a two Python scripts: 1. Name your first script roman_numerals.py 2. Name your second script user_input.py 3. The goal of this projects is to practice the principles of abstraction while adding in an element of selection. How much you abstract your code is up to you, but you...
The following condensed income statements of the Jackson Holding Company are presented for the two years ended December 31, 2021 and 2020:
The following condensed income statements of the Jackson Holding Company are presented for the two years ended December 31, 2021 and 2020: 2021 2020 Sales revenue $ 16,800,000 $ 11,400,000 Cost of goods sold 10,100,000 6,900,000 Gross profit 6,700,000 4,500,000 Operating expenses 3,920,000 3,320,000 Operating income 2,780,000 1,180,000 Gain on sale of division 780,000 — 3,560,000 1,180,000 Income tax expense 890,000 295,000 Net income $ 2,670,000 $ 885,000 On October 15, 2021, Jackson entered into a tentative agreement to sell...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT