Financial position of a company and impact of taking on a green project

[et_pb_section fb_built="1" specialty="on" _builder_version="4.9.3" _module_preset="default" width="100%" custom_padding="0px|0px|0px|||"][et_pb_column type="3_4" specialty_columns="3" _builder_version="3.25" custom_padding="|||" custom_padding__hover="|||"][et_pb_row_inner _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet" custom_padding="28px|||||"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" hover_enabled="0" sticky_enabled="0"]

QUESTION  

    1.  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.

[/et_pb_text][et_pb_text _builder_version="4.9.3" _module_preset="default" width_tablet="" width_phone="100%" width_last_edited="on|phone" max_width="100%"]

 

Subject Business Pages 11 Style APA
[/et_pb_text][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner module_class="the_answer" _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" width="100%" custom_margin="||||false|false" custom_margin_tablet="|0px|||false|false" custom_margin_phone="" custom_margin_last_edited="on|desktop"]

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.

  1.  

     

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.

[/et_pb_text][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|desktop" custom_padding="60px||6px|||"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" min_height="34px" custom_margin="||4px|1px||"]

Related Samples

[/et_pb_text][et_pb_divider color="#E02B20" divider_weight="2px" _builder_version="4.9.3" _module_preset="default" width="10%" module_alignment="center" custom_margin="|||349px||"][/et_pb_divider][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner use_custom_gutter="on" _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px||" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet" custom_padding="13px||16px|0px|false|false"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_blog fullwidth="off" post_type="project" posts_number="5" excerpt_length="26" show_more="on" show_pagination="off" _builder_version="4.9.3" _module_preset="default" header_font="|600|||||||" read_more_font="|600|||||||" read_more_text_color="#e02b20" width="100%" custom_padding="|||0px|false|false" border_radii="on|5px|5px|5px|5px" border_width_all="2px" box_shadow_style="preset1"][/et_pb_blog][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type="1_4" _builder_version="3.25" custom_padding="|||" custom_padding__hover="|||"][et_pb_sidebar orientation="right" area="sidebar-1" _builder_version="4.9.3" _module_preset="default" custom_margin="|-3px||||"][/et_pb_sidebar][/et_pb_column][/et_pb_section]