Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you solve the Proforma using the Facts provided? Taylor Auto Repair & Maintenance Case Facts and Assumptions Module 10 Exercise Taylor Auto Repair wants
Can you solve the Proforma using the Facts provided?
Taylor Auto Repair \& Maintenance Case Facts and Assumptions Module 10 Exercise Taylor Auto Repair wants to evaluate the possibility of adding additional bays to their existing facility to increase volume. The new bays would be identical to the existing bay, so many of the inputs would be identical in proportion to sales. In order to add additional bays, the facility would need to lease more space in its' building, and purchase new equipment. The facility would be constructed in 2021, and begin operations in 2022. Using the 2020 operating results for Taylor, create pro forma financial statements that can measure the feasibility and financial performance of this potential project. Please consider the following facts: $38,000 Revenue attributed to New Repair Bays in 2022 3.50% Repair Revenue Growth YoY The following Items should grow in proportion to revenue: COGS Salaries Benefits \& Pensions Advertising Sales, General \& Administrative (SG\&A) Repairs Insurance Expense Miscellaneous Expenses Rent is usually determined as the price per square foot per year as follows: Architectural, Installation and Construction Fees should be categorized as Professional Fees on the IS Additional facts to consider; 12.85\% Payroll tax rate payable on Wages \& Salaries (FICA, Medicare, FUTA, SUTA) 40.00% Dividend rate of Net Income paid out as dividends as required by the BoD $38,000 Annual depreciation expense attributable to existing equipment $50,000 Annual principle payments on notes payable only if net income is positive (will reduce principle amount for next year) 27.00% Income Tax Rate charged on EBT (if EBT is positive) NET OPERATING INCOME $ 60,542$Step 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