Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedUse 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 Subcontractors

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Thomas Garman, Raymond Forgue

12th edition

9781305176409, 1133595839, 1305176405, 978-1133595830

More Books

Students also viewed these Finance questions