9F1FB2BF-41AF-4861-B348-E209B1DF0C5C.jpeg 1A745EC XXXXXXXXXXB3D2-6D492962B404.jpeg Proficiency Finance Fall 2015 Marsh Corporation DecJanFebMar Projected Unit Sales Add: Desired Ending Inventory...

1 answer below »
Could you fill in the spreadsheet using the marsh corporation information on the pages provided?



9F1FB2BF-41AF-4861-B348-E209B1DF0C5C.jpeg 1A745EC0-7213-4004-B3D2-6D492962B404.jpeg Proficiency Finance Fall 2015 Marsh Corporation DecJanFebMar Projected Unit Sales Add: Desired Ending Inventory Less: Beginning Inventory Units to be Produced Marsh Corporation Monthly Cash Receipts NovDecJanFebMar Sales Collections at 50% Collections at 50% Total Collections Cash Payments JanFebMar Units to be Produced Material Labor Overhead Selling & Administration Interest Taxes Dividends Total Payments Monthly Cash Flow JanFebMar Cash Receipts Cash Payments Net Cash Flow Cash Budget JanFebMar Net Cash Flow Beginning Cash Balance Cumulative Cash Balance Loans (Repayments) Cumulative Loans Marketable Securities Cumulative Marketable Securities Ending Cash Balance
1a745ec0-7213-4004-b3d2-6d492962b404-zctak42x.jpeg 9f1fb2bf-41af-4861-b348-e209b1df0c5c-xniqarma.jpeg 1-c4ilznj3-bcvlfbsc.pdf 2-1lkzneut-yndwqp4c.pdf financeartifact-1-dohr1ozx-0ppgoeyx.xlsx
Answered 6 days AfterMay 12, 2021

Answer To: 9F1FB2BF-41AF-4861-B348-E209B1DF0C5C.jpeg 1A745EC XXXXXXXXXXB3D2-6D492962B404.jpeg Proficiency...

Khushboo answered on May 19 2021
157 Votes
Proficiency Finance Fall 2015
                Marsh Corporation
                Dec    Jan    Feb    Mar
    Projected Unit Sales            1500000    1700000    1200000    1400000
    Add: Desired Ending Inventory            2900000    2600000    3400000    4500000            1700000
    Less: Beginning Inventory            2600000    2900000    2600000    3400000
    Units to be Produced            1800000    1400000    2000000    2500000
                Marsh Corporation
                Monthly Cash Receipts
            Nov    Dec    Jan    Feb    Mar
    Sales        175000    232500    263500    186000    217000
    Collections at 50%            87500    116250    131750    93000
    Collections at 50%                87500    116250    131750
                
    Total Collections                203750    248000    224750
                Cash Payments                            Marsh Corporation
                    Jan    Feb    Mar                Pro Forma Income Statement
    Units to be Produced                1400000    2000000    2500000
    Material...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?