Complete the assets of the pro forma balance sheet

Assignment Help Financial Management
Reference no: EM13947207

Provincial imports has assembled 2015 financial statement income and balance sheet and financial projections for use in preparing financial plans for the coming year 2016

2015 statement

Sales revenue 5,010,000

Less costs of goods sold 2,759,000

Gross profits 2,251,000

Less operating expense 851,000

Operating profits 1,400,000

Less interest expense 196,000

Net profits before taxes 1,204,000

Less tax ( rate 40%) 481,600

Net profits after tax 722,400

Less cash dividends 325,080

To retained earnings 397,320

Balance Sheet 2015


Cash: $203,000

Marketable Securities: $216,000

Accounts Receivable: $627,000

Inventories: $498,000 Total

Current Assets: 1,544,000

Net Fixed Assets: 1,400,000

Total Assets: 2,944,000

Liabilities and SE

Accounts Payable: 702,000

Taxes Payable: 95,000

Notes Payable: 197,000

Other Current Liabilities: 4,700

Total Current Liabilities: 998,700

Long Term Debt: 497,300

Common Stock: 70,000

Retained Earnings: 1,378,000

Total Liabilities & Equity: 2,944,000

Info related to financial projections for 2016 is

1: projected sales are 6,008,000

2: cost of goods sold in 2015 include 999,000 in fixed costs

3: operating expense in 2015 include 247,000 in fixed costs

4: interest expense will remain unchanged

5: the firm will pay cash dividends amounting to 45% of net profits after taxes

6: cash and inventories will double

7: marketable securities, notes payable, long term debt, and common stock will remain unchanged

8: accounts receivable, accounts payable, and other current liabilities will change in direct response to the change in sales

9:!a new computer costing 348,000 will be purchased during the year. Total depreciation for the year will be 120,000

10: the tax rate will remain at 40%

Prepare a pro forma for year ended December 31 2016 using fixed cost data to improve the accuracy of the percent of sales method


Less cost of goods sold=

Gross profits=

Less operating expenses=

Operating profits=

Less interest expenses =

Net profit before taxes =

Less tax rate (40%)=

Net profits after taxes =

Less cash dividends (45%)=

To retained earmings=

Prepare a pro forma balance sheet as of dec 31 2016 using info given and judgemental approach. Include a reconciliation of the retained earnings acct. NOTE taxes payable for 2016 are about 19.4253% of the 2015 taxes on the income statement . The pro forma value is obtained by taking 19.4253% of the 2016 taxes . Complete the assets of the pro forma balance sheet as of dec 31 2016


Marketable securities =

Acct receivable =


Total current assets=

Net fixed assets =

Total assets=complete liabilities and equity part of pro forma balance sheet as of December 31 2016 ( judgemental method)

Accounts payable =

Taxes payable =

Notes payable=

Other current liabilities=

Total current liabilities=

Long term debt=

Common stock=

Retained earnings external finds required =

Total liabilities and stockholders equity=

using the judgmental approach the external finds requirement =

Reference no: EM13947207

Most real estate loans have definite term to maturity

Globalization of the real estate capital market has resulted in. Most real estate loans have a definite term to maturity, stated in years. The majority of home loans will typi

Capital accounts at end of first year of operation for firm

Show the capital accounts at the end of the first year of operation for a firm that, at the beginning of the year, issued 50,000 shares of $1.50 par value common stock for $15

What is value of call option on stock with strike price

A stock is currently priced at $64 and has an annual standard deviation of 44 percent. The dividend yield of the stock is 3.1 percent, and the risk-free rate is 6.1 percent. W

How many fijian dollars do you need to buy a yen

A Japanese yen is worth $0.0050, and a Fijian dollar (F$) is worth $0.5190. What is the value of the yen in Fijian dollars (i.e., how many Fijian dollars do you need to buy a

What will the ex-dividend price of the stock

Amos owns 1,200 shares of Fasteners, Inc. stock. The stock closed today at $41.20 a share. Tomorrow, the firm will pay its annual dividend of $.70 a share. The tax rate on div

Calculate the number of shares issued through this IPO

Hughes Technology Corp. recently went public with an initial public offering in which it received a total of $62.15 million in new capital funding. Calculate the number of sha

At what rate does the firm break even

Consider a firm with a contract to sell an asset for $137,000 five years from now. The asset costs $73,000 to produce today. Given a relevant discount rate on this asset of 13

An investment under consideration has a payback

An investment under consideration has a payback of eight years and a cost of $877,000. Assume the cash flows are conventional. If the required return is 10 percent, what is th


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd