Details of this Paper

create a pro forma statement. The microsoft word includes the

Description

solution


Question

create a pro forma statement.;Attachments Preview;Book1.xlsx Download Attachment;Assumptions;month of sale;0.15;0.15;0.1;0.45;0.1;0.01;0.05;month after sale;2nd month after sale;3rd month after sale;Discount;Uncolectibles;Targeted minimum;Next month saleries and wages;Account payable;Notes payable;Raw material;Salaries and wages;Utility and communications expenses;Insurance expense;Dividend;Depriciation;10,000;0.7;0.8;27000;0.02;5225;0.011;0.5% of prevoios month ending inventory;10,000 per quarter;0.5%% of net fixed assets per month;Cash Budget;April;Sales;Cash Receipts;Discount;Collection current 15%;Same month 15%;One month later 10%;Two months later 45%;Three months later 10%;Total Cash Receipts;Cash Disbursements;Purchases;Wages and salaries;Utility and communication expense;410,000;615;61,500;61500;286,385;35200;9735;May;July;August;September;October November;December January February;375,000 350,000 300,000;220,000 250,000;290,000;375,000 350,000 370,000;Indput

 

Paper#27068 | Written in 18-Jul-2015

Price : $37
SiteLock