Question: Create 4 pro formas : Your Proformas should include a beginning point at 06/30/14 with a 6-month stub-year (BE SURE TO TAKE NOTE THE EXERCISE

Create 4 pro formas : Your Proformas should include a beginning point at 06/30/14 with a 6-month stub-year (BE SURE TO TAKE NOTE THE EXERCISE HAS A STUB YEAR - this impacts your Pro-forma calculations), then YE 12/31/14, 12/31/15, 12/31/16, 12/31/17, 12/31/18, & 12/31/19.

***CREATE INCOME STATEMENT PRO FORMA 1ST***

Southwest Trading CompanyAssumptions:Cost of Goods SoldDays A/RInventory turnoverDays Accts PaySales ProjectionsG&A Ex

**USING THESE CATEGORIES***

For your Pro-Forma Balance Sheet use the following categories:06/01/1412/31/14.........( (hold constant)CashAccounts Rec

12/31/14For your Pro-Forma Income Statement use the following categories:06/01/14SALESCost of Goods SoldGross MarginSel For your Pro-Forma Cash Budget uses the following categories:CASH SALES:Net SalesLess Change in A/RTOTAL CASH RECEIPTSCA For your Pro-Forma Collateral Schedule use the following categories:COLLATERAL SCHEDULE:Cash (Remains constant at the $20,0

Southwest Trading Company Assumptions: Cost of Goods Sold Days A/R Inventory turnover Days Accts Pay Sales Projections G&A Expenses Other Expenses Selling expenses Depreciation Tax Rate 63.00% of sales 48.00 Days 3.00 times 28.00 Days 2014 2015 2016 2017+ $275,000 $675,000 $800,000 $900,000 $70,000 $100,000 $120,000 $120,000 $30,000 SO SO SO 12.00% of sales 10 yr. straight line 34.00%

Step by Step Solution

★★★★★

3.39 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Sales cost of sales Gross Profit Less G A Expenses Other expenses Salling ex... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

30 in. Design stirrups for one of the beams shown below. The flooring system is simply supported and the span length is 30 ft measured from the face of the support. Usef'c = 4000 psi and fy = 60,000...

Inventory turnover is calculated as cost of goods sold divided by ending inventory . 1. True 2. False

Using the following information, prepare the Cost of Goods Sold section of an income statement. Purchases Discounts .............. $ 8,500 Merchandise Inventory, December 31 ....... 189,000 Purchases...

Prepare your preliminary business case report by analyzing financial and non-financial data from the case information provided below. You will need to undertake and include the following: Create a...

from this consolidated financial statement can you tell me the net income and total revenues ORANGE REGIONAL MEDICAL CENTER Consolidated Financial Statements December 31, 2012 and 2011 (With...

Hi Experts, it is a big question, do question a & b first, i will post again. You must answer ALL the questions. (Total 100 marks) You just graduated from a university renowned for its rigorous...

It is Snapchat A which is found in your course pack. You are to turn in an excel a) excel spreadsheet with formulas for calculations. The spreadsheet should show cash flow, WACC calculation, firm...

I need all calculation steps for weights, cost of debts, cost if equities, and weighted average cost of capital !! I need steps showing converting (unlevered) beta to unlevered (levered) bets !! Does...

Hi, For the course Financial Statement Analysis, I had to do an analysis of General electric. One of the questions was to make reformulated balance sheet, cash flow statement, income statement and...

Please Provide a 2 to 3 page article review for each, there attached on this question. Your discussion should include a brief summary (including the big ideas or major points of the article) along...

Innobus Analysis, about Porter's Five Forces - Threat from Competing Products ( it is not an electric buses) it should be car need a lot of information on this part

The average student loan debt is reported to be $25,235. A student belives that the student loan debt is higher in her area. She takes a random sample of 100 college students in her area and...

A coffee house finds that its weekly profit P (measured in dollars) as a function of the price x (measured in dollars) it charges per cup of coffee is given by the function m, defined by m(x) = -300x...

Who are the Public-private partners involved in the Downtown Commercial & Residential Building Improvement Program in the City of Orlando? What Nonprofits are involved in the Downtown Commercial &...

2. A local charity is selling one thousand raffle tickets at $1 a piece. The grand prize is $250, with two second prizes of $100, and five third prizes of $50. Part A: Fill in the probability...

0 = are length -19m 0=? radius of the circle = 7m rad. Round your answer to two decimal places.

8) Your corporation is evaluating four investments. Management plans to buy the properties today and sell them four years from today. The annual discount rate for these investments is 15%. The...

Extend Algorithms 3.4 and 3.5 to include as output the first and second derivatives of the spline at the nodes.

The two-dimensional wave equation is given by By letting ?jm,n denote the finite difference approximation of ?(xm, zn, tj), show that the finite difference scheme for the wave equation is Where h =...

Two identical antennas in an anechoic chamber are separated by 12 m and are oriented for maximum directive gain. At a frequency of 5 GHz, the power received by one is 30 dB down from that transmitted...

A lossless transmission line operating at 4.5 GHz has L = 2.4H/m and Zo = 85 . Calculate the phase constant and the phase velocity u.

Debra paid $99,615 for a $100,000 T-bill with 30 days remaining until maturity. What (annual) rate of interest will she earn? (Taken from CIFP course materials.)

Doina borrowed $7000 from her credit union on a demand loan on July 20 to purchase a motorcycle. The terms of the loan require fixed monthly payments of $1400 on the first day of each month,...

Dr. Robillard obtained a $75,000 operating line of credit at prime plus 1%. Accrued interest up to but not including the last day of the month is deducted from his bank account on the last day of...