Question
Use the following assumptions for OH expenditures & apply this for the company-wide cash flow projection: - Month 1, pay $500,000 for annual insurance premiums
Use the following assumptions for OH expenditures & apply this for the company-wide cash flow projection: - Month 1, pay $500,000 for annual insurance premiums - Month 1, Licenses/Subscriptions/Fees of $25,000 - Monthly, pay OH salaries of $100,000 each month - Monthly, Employee benefits of $10,000 - Monthly, pay facility rent of $20,000 each month - Monthly, pay utilities of $1,250 each month - Monthly, Software Maintenance of $$2,500 each month - Monthly, Office Supplies & Postage of $1,000 each month - Monthly, Meals & Travel of $2,500 each month - Month 2, 4, 8 Legal Services of $15,000; $10,000 and $15,000, respectively - Month 12, Charitable Contribution of $12,000 - Assume Quarterly interest payments are made in each of Months 3, 6, 9 & 12 o Quarterly, interest of $5,000 each quarter o Quarterly, debt (principal) $50,000 each quarter o Quarterly, estimated taxes of $100,000 each quarter
Use the following information for Projects 1-3 In the cash flow template, ensure to calculate monthly and cumulative cash flow for each project. Fee awarded: Rention Rate: Project Time (mos): Billing Schedule Owner Pymt Terms Project #1 2,000,000 10% 6 1/6 billed monthly net 30 days Project #2 9,000,000 5% 18 1/18 billed monthly net 30 days Project #2 6,000,000 10% 12 25% billed every 3 months net 30 days 333,333.33 500,000 1,500,000 Cost Burdened Total Cost Cost Burdened Total Cost Cost Burdened Total Cost 135,000 Cost Estimates - - Labor Estimate (per month): Materials Estimate (per month): Subcontracting Estimate (per month): Equipment Estimate (per month): 85,000 65,000 20,000 212,500 81,250 22,000 510,000 390,000 120,000 210,000 75,000 525,000 93,750 3,780,000 1,350,000 337,500 81,250 1,620,000 780,000 65,000 Assumptions, for above: Assume wages worked w/in the month are paid by the end of the month Assume owner doesn't prepay for materials - Assume PwP terms for Subcontracting Equipment is managed by Subcontractors Use the following information for Projects 1-3 In the cash flow template, ensure to calculate monthly and cumulative cash flow for each project. Fee awarded: Rention Rate: Project Time (mos): Billing Schedule Owner Pymt Terms Project #1 2,000,000 10% 6 1/6 billed monthly net 30 days Project #2 9,000,000 5% 18 1/18 billed monthly net 30 days Project #2 6,000,000 10% 12 25% billed every 3 months net 30 days 333,333.33 500,000 1,500,000 Cost Burdened Total Cost Cost Burdened Total Cost Cost Burdened Total Cost 135,000 Cost Estimates - - Labor Estimate (per month): Materials Estimate (per month): Subcontracting Estimate (per month): Equipment Estimate (per month): 85,000 65,000 20,000 212,500 81,250 22,000 510,000 390,000 120,000 210,000 75,000 525,000 93,750 3,780,000 1,350,000 337,500 81,250 1,620,000 780,000 65,000 Assumptions, for above: Assume wages worked w/in the month are paid by the end of the month Assume owner doesn't prepay for materials - Assume PwP terms for Subcontracting Equipment is managed by SubcontractorsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started