QUESTION
-
-
Financial position of a company and impact of taking on a green project
Based on your readings, use of technology, literature, and other sources do the following:
1. Review the financial statements and notes presented for XYZ Construction Co Inc and discuss their current financial position. XYZ Sample Financial Statements.pdf XYZ Sample Financial Statements.pdf - Alternative Formats
2. Review the assumptions XYZ Company Project Assumptions(5).docx XYZ Company Project Assumptions(5).docx - Alternative Formats - Alternative Formats made by XYZ Construction Co Inc. if they take on the green project.
3. Complete the spreadsheet with the required calculations Excel Project template(5).xls Use the template provided here for the overall project Project Format Template(1).doc Project Format Template(1).doc - Alternative Formats
4. Based on your analysis of the documents and your calculations discuss if you think XYZ should take on the green project. You want to also include in your analysis any qualitative factors beyond the quantitative calculations that were used to come to this conclusion. This may include the ability to obtain financing, staffing needs, project management/oversight, impact on other jobs, etc.The body of the paper should be 4-5 pages (not including title page, abstract, or references) typed. Embed your Excel calculations into the paper as exhibits.
This paper requires a minimum of three references: academic journals, professional journals, and/or appropriate authoritative references from the library, not websites or blogs.
All papers are submitted in APA format.I have an example uploaded as well.
-
Subject | Business | Pages | 11 | Style | APA |
---|
Answer
Financial Position of XYZ Company
& Impact of taking a Green Project
Abstract
The final position for XYZ is stable however it needs to implement the green project as it is profitable in future. The traditional setup for XYZ Company initially had a contribution margin of $542208 compared to 649972 in case of the green project, an increase of 107,764. The contribution margin ratio for the traditional setup amounted to 13.74% compared to 15.47%. The Fixed General & administrative expenses amounted to $267, 808 for both scenarios. The current ratios are calculated to indicate a company’s liquidity status and they provide an evaluation on the company’s ability to pay its debts and honor other obligations. The current ratios below indicate that XYZ are 1.65. The ratios indicate the financial performance and trend forecasts for future implementation and would reduce to 1.55 if the company goes green. The company’s liquidity would reduce relatively. Liquidity ratios, financial leverage, profitability and management ratios are some of the ratios that this paper seeks to calculate and apply them in ratio analysis. The projected estimates that are related to the Green project are growing very fast. It would be more productive if the new project would be implemented hence XYZ should continue with its project.
Introduction
Financial ratios are used to illustrate the performance of a company. The ratios indicate the financial performance and trend forecasts for future implementation. Liquidity ratios, financial leverage, profitability and management ratios are some of the ratios that this paper seeks to calculate and apply them in ratio analysis. This paper evaluates the financial performance of XYZ Company in relation to the green project in an effort to determine if it would be a good investment project.
Analysis of Part A Ratios
Part A: Ratios
Ratios are utilized to compare the financial information available in a company’s financial statements. They are used to determine different aspects of a company’s financial performance such as liquidity, solvency, and profitability (Corporate finance Institute, 2021).
The current ratios are calculated to indicate a company’s liquidity status and they provide an evaluation on the company’s ability to pay its debts and honor other obligations. The current ratios below indicate that XYZ are 1.65 and would reduce to 1.55 if the company goes green. (XYZ Construction Co. Inc., n, d). The company’s liquidity would reduce.
. Current Ratio |
|||
Traditional |
Green |
Difference |
|
Current Assets |
893,868 |
1,021,987 |
128,119 |
Current Liabilities |
541,697 |
657,715 |
116,018 |
Current Ratio |
1.65 |
1.55 |
(0.10) |
|
Traditional |
Green |
Difference |
Contract Receivables |
605,050 |
650,250 |
45,200 |
Revenue |
3,946,862 |
4,200,250 |
253,388 |
Collection Period |
55.95 |
56.51 |
0.55 |
Receivable Turns |
6.52 |
6.46 |
(0.06) |
Accounts Payable to Revenue Ratio |
|||
Traditional |
Green |
Difference |
|
Accounts Payable |
247,335 |
290,254 |
42,919 |
Revenue |
3,946,862 |
4,200,250 |
253,388 |
Accounts Payable to Revenue Ratio |
6.27% |
6.91% |
0.64% |
Gross Profit |
|||
Traditional |
Green |
Difference |
|
Gross Profit |
641,343 |
758,029 |
116,686 |
Revenue |
3,946,862 |
4,200,250 |
253,388 |
Gross Profit Margin |
16.25% |
18.05% |
1.8% |
Profit Margin |
|||
Traditional |
Green |
Difference |
|
Net Profit Before Taxes |
277,029 |
393,715 |
116,686 |
Revenue |
3,946,862 |
4,200,250 |
253,388 |
Profit Margin |
7.02% |
9.37% |
2.4% |
Profit Margin |
|||
Traditional |
Green |
Difference |
|
Net Profit After Taxes |
171,629 |
293,715 |
122,086 |
Revenue |
3,946,862 |
4,200,250 |
253,388 |
Profit Margin |
4.35% |
6.99% |
2.6% |
Analysis
Collection receivables refer to the period it takes a company to collect all its debts and accounts receivable. It is important as it indicates the time it takes for the company cash to be collected from its debtors. It takes about 56 days for the company to collect all its debt (Corporate finance Institute, 2021). The collection period would remain the same even after the company adopts green measures.
Implementing the green project would increase the company’s profit margin from 4.35% to 6.99% an increase of 2.6%. The Net profit margin before taxes amounts would increase from 7.02% to 9.37% when the green project is implemented. The amount increased by 2.4%. The receivable turns refers to the average number of times the accounts receivables collected every year. The receivable turnover ratio is the number of accounts or times the receivable is collected every year. It is an efficiency ratio that indicates a company’s financial performance. The higher the ratios the better are its advantages.
Analysis of Part B Work Flow Schedule
Task |
Cost |
Start |
Finish |
Month 1 |
Month 2 |
Month 3 |
Month 4 |
Month 5 |
Month 6 |
Excavation |
1,800 |
Month 1 |
Month 1 |
1,800 |
|
|
|
|
|
Footings and Foundation |
11,600 |
Month 1 |
Month 1 |
11,600 |
|
|
|
|
|
Waterproofing |
800 |
Month 2 |
Month 2 |
|
800 |
|
|
|
|
Backfill & Under Slab Gravel |
1,500 |
Month 2 |
Month 2 |
|
1,500 |
|
|
|
|
Structural |
3,600 |
Month 2 |
Month 4 |
|
900 |
900 |
900 |
|
|
Electrical |
9,000 |
Month 2 |
Month 4 |
|
3,000 |
3,000 |
3,000 |
|
|
Plumbing |
3,000 |
Month 2 |
Month 4 |
|
1,000 |
1,000 |
1,000 |
|
|
Heating |
4,200 |
Month 2 |
Month 4 |
|
1,400 |
1,400 |
1,400 |
|
|
Roof |
3,700 |
Month 5 |
Month 5 |
|
|
|
|
3,700 |
|
Cleanup |
800 |
Month 6 |
Month 6 |
|
|
|
|
|
800 |
|
|
|
|
13,400 |
8,600 |
6,300 |
6,300 |
3,700 |
800 |
The total expenses for th e first month would be for excavation, footings and foundation that would cost $13400. The second month it would cost $8600 and it would include waterproofing, backfilling, under slab gravel, structural, electrical, plumbing and heating. The last four activities would continue for another two months while the fifth and final month it would cost $3700 and $800 for roofing and cleanup respectively.
Analysis of Part C Expenses
The current cost amounted to 26980 so that but they were forecasted to increase by 8 and 9% respectively.
Expenses |
|||
Traditional |
Green |
Difference |
|
Current cost for other expenses * |
26,980 |
26,980 |
|
% increase |
8% |
9% |
|
Annual Budget for other expenses |
29,138.40 |
29,408.20 |
270 |
Expenses |
|
||
Traditional |
Green |
Difference |
|
Current cost for professional fees * |
16,893 |
17,893 |
(1,000) |
Inflation rate |
0.045 |
0.045 |
- |
Year 5 |
5 |
5 |
- |
3,801 |
|
(3,801) |
|
Projected cost for professional fees |
20,694 |
17,893 |
(4,801) |
Professional fee increased by a rate of 0.045. The total projected cost for professional services which amounted to $20,694 and 17,893 respectively.
Analysis of Part D Payroll
Annual Salary |
45,000 |
$/Amount |
|
Wages |
46,000 |
Bonus |
1,000 |
$/Amount |
|
Allowances |
- |
|
|
|
|
FICA |
2,852 |
|
|
|
|
Medicare |
667 |
FICA Rate |
6.20 |
% |
|
FUTA |
42 |
FICA Limits |
106,800 |
$ |
|
SUTA |
210 |
Medicare |
1.45 |
% |
|
Worker's Comp. |
1,955 |
FUTA Rate |
0.60 |
% |
|
General Liability |
469 |
FUTA Limits |
7,000 |
$ |
|
Profit Sharing |
11,500 |
SUTA Rate |
3.00 |
% |
|
|
- |
SUTA Limit |
7,000 |
$ |
|
|
- |
Worker's Comp. Rate |
4.25 |
$/per 100 |
|
|
- |
General Liability Rate |
1.02 |
% |
|
Total |
63,695 |
Profit Sharing * |
25.00 |
% |
|
|
|
Profit Sharing Limit |
100 |
% |
|
Monthly Cost |
5,308 |
|
|
|
|
|
|
|
|
|
|
Burden Markup (%) |
41.5% |
The burden markup amounted to 41.5% allowing the employees to earn 42 cents as an expense to the company. The company pays bonuses and makes other arrangements to provide incentives to the employees including profit sharing schemes.
Analysis of Part E Margins
The contribution margin evaluates a company’s variable sales and differences between sales, and other costs (Lumen, 2020). It reveals the amount set aside in China. The higher the ratio the more the increase in students
Contribution Margin |
|||
Traditional |
Green |
Difference |
|
Revenue |
3,946,862 |
4,200,250 |
253,388 |
Contract Costs |
3,305,519 |
3,442,221 |
136,702 |
Variable General and Admin Expenses |
99,135 |
108,057 |
8,922 |
Contribution Margin |
542,208 |
649,972 |
107,764 |
Contribution Margin Ratio |
|||
Contribution Margin Ratio |
13.74% |
15.47% |
1.7% |
Break Even Volume |
|||
Traditional |
Green |
Difference |
|
Fixed General and Admin Expenses |
267,808 |
267,808 |
- |
Contribution Margin Ratio |
13.74% |
15.47% |
1.74% |
Break Even Volume |
1,949,439 |
1,730,630 |
(218,809) |
Break Even Contribution Margin Ratio |
|||
Traditional |
Green |
Difference |
|
Fixed General and Admin Expenses |
267,808 |
267,808 |
- |
Revenue |
3,946,862 |
4,200,250 |
253,388 |
Break Even Contribution Margin Ratio |
6.79% |
6.38% |
-0.4% |
Profit and Overhead Markup |
|||
Traditional |
Green |
||
Gross Profit Margin(from Ratios tab) |
16.2% |
18.0% |
1.8% |
Profit and Overhead Markup |
19.33% |
21.95% |
2.6% |
The traditional setup for XYZ Company initially had a contribution margin of $542208 compared to 649972 in case of the green project, an increase of 107,764. The contribution margin ratio for the traditional setup amounted to 13.74% compared to 15.47%. The Fixed General & administrative expenses amounted to $267, 808 for both scenarios. It provides a breakeven of 1949439 for the traditional setup while the one for Green setup has a breakeven of 1730630. Compared to the total revenues the breakeven contribution ratio amounted to 6.79% and 6.38%.
Conclusions and Overall Recommendations
Most of the ratios for the green project are fairly similar to those of traditional XYZ setup. The contribution margin ratio for the traditional setup amounted to 13.74% compared to 15.47%. The Fixed General & administrative expenses amounted to $267, 808 for both scenarios. It provides a breakeven of 1949439 for the traditional setup while the one for Green setup has a breakeven of 1730630. Compared to the total revenues the breakeven contribution ratio amounted to 6.79% and 6.38%. XYZ company should implement the green project as it will increase the company’s profitability.
References
Corporate finance Institute (2021). Ratio Analysis retrieved September 21, 2021 from https://corporatefinanceinstitute.com/resources/knowledge/finance/ratio-analysis/
Corporate finance Institute (2021). Average Collection Period retrieved September 21, 2021 from https://corporatefinanceinstitute.com/resources/knowledge/accounting/average-collection-period/
Corporate finance Institute (2021). Accounts Receivable Turnover ratio retrieved September 21, 2021 from https://corporatefinanceinstitute.com/resources/knowledge/accounting/accounts-receivable-turnover-ratio/
Lumen (2020). Contribution Margin Ration retrieved September 22, 2021 from https://courses.lumenlearning.com/wm-accountingformanagers/chapter/contribution-margin-ratio/
XYZ Construction Co. Inc. (n, d). Financial Statements, Sample Financial Statement Pdf.