Preview

Financial Report Assignment

Powerful Essays
Open Document
Open Document
3922 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Financial Report Assignment
Finance assignment #2 – Capital Budgeting Example

Team Information
Alias
Name
Student Number
*Tiffany
HUANG Wan Hong
14430819
Kelly
ZHAO Yun
14430835
Cara
ZHU Zhen Yi
14410273
Sherry
TAN Xin Yi
14431092
Priscilla
HU Xiao Ling
14431130
L.X
LIU Xun
14433176
Tiffany
CHO Tiffany
14444984

Introduction
XYZ Bicycle Co.Ltd. is a bicycle production company, it is considering a new plan that whether to introduce a new mountain bike product line, for the reason that the company holds the view that this plan will increase its profits. However, this company is very cautious and it wants to ensure if this plan is perfect. This report will analyze this project by using relevant knowledge to decide if the company should introduce the new mountain bike product line.

The relevant financial data has already been shown in the case, moreover, there have two opinions if the company adopts the new plan. The first one is that the company purchases new equipment at the first time; another one is that the company uses the current excess capacity to produce the maintain bike for two years, and it will buy the new equipment in the year two. This report will analyze these two kinds of opinions and make a conclusion to choose the best one.
Based the data included in the case, firstly we have recorded the necessary data in a chart, and this chart is shown as below:

Reference Chart
Year
1
2
3
4
5
Sales Volume
1400
1525
1730
1650
1420
Sales Revenue
8.680
9.455
10.726
10.230
8.804
Variable Costs
3.906
4.255
4.827
4.604
3.962
Fixed Costs
2.1
2.1
2.1
2.1
2.1
Total Costs
6.006
6.355
6.927
6.704
6.062
Depreciation
Case 1

1.343
2.302
1.644
Depreciation
Case 2
1.343
2.302
1.644
1.174
0.839
(The unit of the price is million)

Step 1
In this case, it seems to be an important decision for XYZ Bicycle Co. Ltd to determine whether to introduce the new mountain bike. As a commercial business entity, XYZ Bicycle Co. Ltd tends to maximum its overall profits which must be one
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Powerful Essays

    Jet2 Task 2
    • 3870 Words
    • 11 Pages

    Jet2 Task 2

    Competition Bikes has prepared a budget for year nine of operations. In reviewing the budget presented several technical areas of concern have been noted. For ease of review, budgetary issues that raise concerns are presented in a bullet format.…

    • 3870 Words
    • 11 Pages
    Powerful Essays
    Read More
  • Good Essays

    JET2 TASK 2
    • 1433 Words
    • 5 Pages

    JET2 TASK 2

    During the evaluation of Competition Bike’s budget schedule a few areas of concerns were identified within the budgeting and proformas. The first area of concern within budget was advertising. The advertising was budgeted for $28,412; they may want to consider increasing their marketing to reach a wider audience to boost sales. In year 6 the advertising was $23,820, then increased year 7 $32,760, and year in 8 decreased to $27,428. They need to increase their exposure within the bike market. They need to consider redoing their website, the website allows them to reach a wider audience 24 hours a day 7 days a week. Increasing advertising could be a favorable outcome on net sales since net sales were down in year 8 by -15%.…

    • 1433 Words
    • 5 Pages
    Good Essays
    Read More
  • Better Essays

    Jet2 Task 2 Essay Example
    • 1914 Words
    • 8 Pages

    Jet2 Task 2 Essay Example

    There are budgetary areas that raise concern in the budget planning of Competition Bikes, Inc. One area is forecasting of the sales budget. The sales projection in units for year 9 is set at 3510. In comparison to year 8, there was a 15% decrease in units sold in comparison to year 7 levels. Due to the present economic situation, there is no support for the projected sales to reflect 3510, as professional rider’s sponsorship is at a decline. The decline is expected to continue for another three years. The sales projections does not seem realistic as going forward there are no discussions as to how to increase sponsorships in the declining market.…

    • 1914 Words
    • 8 Pages
    Better Essays
    Read More
  • Good Essays

    Jet2 Task 2 Financial Analysis Paper
    • 2299 Words
    • 10 Pages

    Jet2 Task 2 Financial Analysis Paper

    For this task I preformed an analysis of the financials of Competition Bikes, Inc. In the following pages I will discuss my findings in detail. I will find weaknesses and strengths as well as indicators of how the company’s financial health is. Also included will be some potential ways to make adjustments to correct the weaknesses. Some of the operational strengths and weaknesses were identified by reviewing the horizontal, vertical, trend, and ratio analysis of the current and past financial situation. For the conclusion the strengths and weaknesses of the internal controls in place will be identified as well as solutions and some possible issues related to the Sarbanes-Oxley…

    • 2299 Words
    • 10 Pages
    Good Essays
    Read More
  • Good Essays

    JET Task 1
    • 3064 Words
    • 13 Pages

    JET Task 1

    When performing financial analysis on Competition Bikes Inc. (CBI) one must start by reviewing the financial status of the internal control operations. This will be completed by reviewing the working capital, horizontal, vertical, ratio, and trend analysis. This will allow projection of any necessary budget limitations. By completing a yearly overhead versus profit projection of performance comparison a budget for materials on a month to month basis will be created.…

    • 3064 Words
    • 13 Pages
    Good Essays
    Read More
  • Better Essays

    JET2 Task 3
    • 2414 Words
    • 8 Pages

    JET2 Task 3

    Part of Competition Bikes’ (CB) main consideration in the decision to merge or acquire Canadian Biking is working capital. Lets use the EBIT – EPS approach to determine how to maximize shareholder return while minimizing the cost of capital. We currently know Canadian Biking’s moderate sales forecast of EBIT figures for the next 5 years (Year 9 – 13), therefore we can apply the EBIT – EPS approach to choose an optimal capital structure.…

    • 2414 Words
    • 8 Pages
    Better Essays
    Read More
  • Good Essays

    Competition Bikes Task 2
    • 1502 Words
    • 7 Pages

    Competition Bikes Task 2

    This report will provide an assessment of Competition Bikes Inc.’s budget. By examining the Budget Schedules and Proformas, the areas of concern…

    • 1502 Words
    • 7 Pages
    Good Essays
    Read More
  • Powerful Essays

    JET2 Financial Analysis Task 5 Part II WGU
    • 4017 Words
    • 13 Pages

    JET2 Financial Analysis Task 5 Part II WGU

    Custom Snowboards Inc. has had increased net sales in the past three years. Net sales went up .23% in year 13 and .93% in year 14. Cost of goods sold (consisting of direct material, labor, and overhead) and in relation Gross Profit, also increased by the same percentages. Using the historical data, we use the trend analysis to determine what sales will be like in future years. The company’s trend analysis shows this increase in net sales and gross profit will continue well into year 17. Using base year 12, historical data shows an increase to 100.2% in year 13 and another .7% increase to 100.9% in year 14. Then to further review the upcoming year’s predictions, Custom Snowboards uses year 14 as the base year at $6,955,200. Year 15 increases to $7,163,856, a 3% increase. Year 16 slows slightly to $7,094,304, down a percent from year 15 but still an increase of 2% from the base year. Year 17 shows net sales at 103.7% of the base year 14 earnings. This indicates the company has worthy cost control in revenue.…

    • 4017 Words
    • 13 Pages
    Powerful Essays
    Read More
  • Good Essays

    Mikes Bikes Report
    • 6037 Words
    • 25 Pages

    Mikes Bikes Report

    JayHsquared is a corporation that was founded in September of 2003, located in Waterloo, Ontario, Canada. The company is the proud producer of mountain and youth bikes. The mission of the firm is to gain loyal customers by being the lead providers of medium quality bikes at moderate prices. Every year, the decisions made by the management of the firm lead to an increase in the company’s shareholder’s value. This value started at $8.96 in 2004 and it increased to $37.03 by 2011. The cumulative change in SHV was 313%. Our advertising for year 2004 was $1,200,000 and by year 2011 it was $4,400,000. The increases in advertising expenditure also lead to an increase of the firm’s awareness. Our mountain bikes started with an awareness of 0.26 and ended with 0.33. In year 2007, the firm had the choice to launch a new line of youth or road bikes. JayHsquared launched youth bikes as the management believed that there would be a larger market for youth bikes than road bikes. After this opportunity, the firm had the choice to introduce all three lines of bikes; our firm choose to continue focusing only on mountain and youth bikes. Our entire competition introduced all three lines of…

    • 6037 Words
    • 25 Pages
    Good Essays
    Read More
  • Good Essays

    In Class Solution Bmgt 417
    • 2229 Words
    • 9 Pages

    In Class Solution Bmgt 417

    37. [LO 3, 4] In year 0, Longworth Partnership purchased a machine for $40,000 to use in its business. In year 3, Longworth sold the machine for $35,000. Between the date of the purchase and the date of the sale, Longworth depreciated the machine by $22,000.…

    • 2229 Words
    • 9 Pages
    Good Essays
    Read More
  • Powerful Essays

    Builtrite - Auditing
    • 14427 Words
    • 58 Pages

    Builtrite - Auditing

    The following pages in this manual contain the solutions to the Biltrite Bicycles, Inc. audit practice case. The solutions are presented by module number. Answers to the narrative questions are presented first, followed by the completed working papers as solutions to those parts requiring audit working paper completion. The completed working papers are also included in the accompanying instructor's resource CD (IRCD) for those preferring to use the computer for viewing the completed audit working papers.…

    • 14427 Words
    • 58 Pages
    Powerful Essays
    Read More
  • Good Essays

    Geniune Motor Products
    • 606 Words
    • 3 Pages

    Geniune Motor Products

    1) GENUINE MOTOR PRODUCTS Revised Pro forma Income Statement For 2007 Sales (1,000,000 units @ $30 per unit) Fixed costs Total variable costs (1,000,000 units @ $18.80 per unit) Operating Income (EBIT) Interest (10.75% x $12,000,000) Earnings before taxes Taxes (35%) Earnings after taxes Shares Earnings per share * Fixed costs include $2,800,000 in depreciation $ 30,000,000 5,800,000 18,800,000 5,400,000 1,290,000 4,110,000 1,438,500 2,671,500 2,320,000 1.15…

    • 606 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Straight-line Depreciation
    • 610 Words
    • 3 Pages

    Straight-line Depreciation

    Balls and Bats, Inc. purchased equipment on January 1, 2005, at a cost of $100,000. The estimated useful life is 4 years with a salvage value of $10,000.…

    • 610 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Jet task 2
    • 421 Words
    • 2 Pages

    Jet task 2

    There are a few areas of concern with the Budget that Competition Bike, Inc. has displayed within their budget for year 9. The most prominent area of concern in is in the Revenue section of the budget. In the budget for year 9, Competition has included units sold to be 3510. This is a lofty prediction given that year 8 had seen such a big decline in that number. In year 8, Competition sold 3400 units, but the previous year had sold around 4000 units, a 15 % decline. The company is hoping for an upswing, but this may be too positive of an estimation. To go with that, Competition is only allowing for $984 more dollars in advertising for year 9. If they had budgeted maybe $2000-$3000 more to this category to get to where their advertising spending was in year 7 when they sold 4000 units, their budget of increased sales in year 9 would not be as suspect.…

    • 421 Words
    • 2 Pages
    Good Essays
    Read More
  • Powerful Essays

    Corporate finance Assignment
    • 1085 Words
    • 7 Pages

    Corporate finance Assignment

    Calculate TRUST’s company after-tax WACC. The risk-free rate was 4.21%, the market risk premium was 6% and the company tax rate was 30%. The WACC should be rounded to four decimal places.…

    • 1085 Words
    • 7 Pages
    Powerful Essays
    Read More

Related Topics