Individual Assignment 1 (30% of the final marks) Based on the above information prepare an academic...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Individual Assignment 1 (30% of the final marks) Based on the above information prepare an academic report that should answer the following questions: Answer the following task: Task 1 A top management must monitor progress at regular intervals to obtain feedback on achievements and to highlight problems requiring attention. Explain with examples the steps on how to obtain the best use of feedback from the budget. (15 Marks) Task 2 An established construction company plan, to prepare its yearly company's budget. Discuss two (2) main budgeting principles appropriate for the company's budget. Explain the relationship between the firm's goal, financial management and capital budgeting related to company's budget. (15 Marks) Task 3 The balance sheet and Income statements of KAREENA Holdings's Company are presented in table 1.0 and table 1.1 below. The company is planning to apply credit facilities from LAYEE Bank. Below are the details of the financial statements. (35 Marks) ASSETS Current assets Cash KAREENA Holding Balance sheet (in Millions of Ringgit) As for December 31, 20x1; 20x2; 20x3 20x1 Government securities (cost) Accounts and notes receivable (net) Inventories Prepaid assets Total current assets Property, plant and equipment (net) Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Liabilities Current Liabilities Note payable Accounts payable Accrued expenses and taxes Total current liabilities Long-term debt, 6% Total liabilities Stockholders' equity Total liabilities and stockholders' equity Table 1.0 26 04 6 28 0.7 14.5 43 32 2.8 09 6.9 3.0 99 8.9 18.8 20x2 1.8 02 8.5 3.2 0.6 14.3 54 19.7 3.7 3.7 1.1 8.5 2.0 10.5 9.2 19.7 20x3 1.8 8.5 2.8 08 13.5 5.9 19.4 4.2 4.1 1 9.3 1.0 10.3 9.1 19.4 Financial Management (BAC3633) Page 3 of 6 Net sales Cost of goods sold Gross margin Selling expenses Administrative expenses Total expenses Earnings (loss) before taxes Income taxes Net income Ratio Current ratio Acid test ratio Inventory turnover (in times) Gross Profit margin Net profit margin Return on total assets Equity relationships Current liabilities Long term Liabilities Shareholders' equity Asset relationship Current assets Property, plant and equipment 20x1 % 20x1 % 24.2 16.9 Calculate the ratios, equity relationship and asset relationship for three consecutive years, 20x1; 20x2; 20x3 in Table 1.2. Provide comments on the obtained results. Table 1.2 7.3 4.3 Table 1.1 2.3 6.6 DO 0.7 0.3 0.4 20x2 % 20x2 % 24.5 17/2 7.3 4.4 2.4 6.8 0.5 0.2 0.3 20x3 % % 20x3 24.9 18 6.9 4.6 2.7 7.3 -0.4 -0.2 -0.2 Based on the obtained results, state whether the LAYEE Bank should grant KAREENA Holding Company and support the answer with facts given in the evaluations. Financial Management (BAC3633) Page 4 of 6 Task 4 AIFAZ Team Sdn Bhd, finds that its growing sales are outstripping its ability to finance its inventory needs and require temporary finance of RM100, 000 during the coming year. Table 2.0 and 2.1 show the most recent financial statements that were provided to its bank as support for the firm's loan request. Imagine you are the bank's financial analyst, answer the following (35 Marks): Assets Liabilities and shareholders' equity AIFAZ Team Sdn Bhd Balance Sheet 31/12/2019 and 31/12/2020 Cash Marketable securities Account receivable Inventory Prepaid rent Total current assets Net plant and equipment Total assets Accounts payable Notes payable Accruals Total Current liabilities Long-term debt Shareholders' funds Total liabilities and equity Table 2.0 2019 (RM) 16,000 7,000 42,000 50,000 1,200 116,200 286,000 402,200 48,000 16,000 6,000 70,000 160,000 172,200 402,200 2020 (RM) 17,000 7,200 38,000 93,000 1,100 156,300 290,000 446,300 55,000 13,000 5,000 73,000 150,000 223,300 446,300 Financial Management (BAC3633) Page 5 of 6 AIFAZ Team Sdn Bhd Income Statement for year ended 31/12/2020 Sales Less: Cost of goods sold Gross profit Less: Expenses Profit before tax Less: Tax Profit after tax Less: Dividends To retained earnings Ratios Current ratio Acid-test ratio Debt ratio Average collection period Inventory turnover Return on total assets Gross profit margin Net profit margin General and administrative Interest Depreciation Total Table 2.1 Industry Norm 1.8 times 0.9 times 0.5 20 days 7 times 8.40% 25% 7.00% Table 2.2 50,000 10,000 30,000 700,000 500,000 200,000 END OF QUESTIONS. 90,000 110,000 27,100 82,900 31,800 51,100 ELLAN Team Sdn Bhd Calculate the financial ratios for 2019 and 2020 corresponding to the industry norms (Table 2.2). Provide comments for each ratio. State the strength and weaknesses of your analysis on AIFAZ Team Sdn. Bhd financial ratios. Advise whether to grant the loan or otherwise. Individual Assignment 1 (30% of the final marks) Based on the above information prepare an academic report that should answer the following questions: Answer the following task: Task 1 A top management must monitor progress at regular intervals to obtain feedback on achievements and to highlight problems requiring attention. Explain with examples the steps on how to obtain the best use of feedback from the budget. (15 Marks) Task 2 An established construction company plan, to prepare its yearly company's budget. Discuss two (2) main budgeting principles appropriate for the company's budget. Explain the relationship between the firm's goal, financial management and capital budgeting related to company's budget. (15 Marks) Task 3 The balance sheet and Income statements of KAREENA Holdings's Company are presented in table 1.0 and table 1.1 below. The company is planning to apply credit facilities from LAYEE Bank. Below are the details of the financial statements. (35 Marks) ASSETS Current assets Cash KAREENA Holding Balance sheet (in Millions of Ringgit) As for December 31, 20x1; 20x2; 20x3 20x1 Government securities (cost) Accounts and notes receivable (net) Inventories Prepaid assets Total current assets Property, plant and equipment (net) Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Liabilities Current Liabilities Note payable Accounts payable Accrued expenses and taxes Total current liabilities Long-term debt, 6% Total liabilities Stockholders' equity Total liabilities and stockholders' equity Table 1.0 26 04 6 28 0.7 14.5 43 32 2.8 09 6.9 3.0 99 8.9 18.8 20x2 1.8 02 8.5 3.2 0.6 14.3 54 19.7 3.7 3.7 1.1 8.5 2.0 10.5 9.2 19.7 20x3 1.8 8.5 2.8 08 13.5 5.9 19.4 4.2 4.1 1 9.3 1.0 10.3 9.1 19.4 Financial Management (BAC3633) Page 3 of 6 Net sales Cost of goods sold Gross margin Selling expenses Administrative expenses Total expenses Earnings (loss) before taxes Income taxes Net income Ratio Current ratio Acid test ratio Inventory turnover (in times) Gross Profit margin Net profit margin Return on total assets Equity relationships Current liabilities Long term Liabilities Shareholders' equity Asset relationship Current assets Property, plant and equipment 20x1 % 20x1 % 24.2 16.9 Calculate the ratios, equity relationship and asset relationship for three consecutive years, 20x1; 20x2; 20x3 in Table 1.2. Provide comments on the obtained results. Table 1.2 7.3 4.3 Table 1.1 2.3 6.6 DO 0.7 0.3 0.4 20x2 % 20x2 % 24.5 17/2 7.3 4.4 2.4 6.8 0.5 0.2 0.3 20x3 % % 20x3 24.9 18 6.9 4.6 2.7 7.3 -0.4 -0.2 -0.2 Based on the obtained results, state whether the LAYEE Bank should grant KAREENA Holding Company and support the answer with facts given in the evaluations. Financial Management (BAC3633) Page 4 of 6 Task 4 AIFAZ Team Sdn Bhd, finds that its growing sales are outstripping its ability to finance its inventory needs and require temporary finance of RM100, 000 during the coming year. Table 2.0 and 2.1 show the most recent financial statements that were provided to its bank as support for the firm's loan request. Imagine you are the bank's financial analyst, answer the following (35 Marks): Assets Liabilities and shareholders' equity AIFAZ Team Sdn Bhd Balance Sheet 31/12/2019 and 31/12/2020 Cash Marketable securities Account receivable Inventory Prepaid rent Total current assets Net plant and equipment Total assets Accounts payable Notes payable Accruals Total Current liabilities Long-term debt Shareholders' funds Total liabilities and equity Table 2.0 2019 (RM) 16,000 7,000 42,000 50,000 1,200 116,200 286,000 402,200 48,000 16,000 6,000 70,000 160,000 172,200 402,200 2020 (RM) 17,000 7,200 38,000 93,000 1,100 156,300 290,000 446,300 55,000 13,000 5,000 73,000 150,000 223,300 446,300 Financial Management (BAC3633) Page 5 of 6 AIFAZ Team Sdn Bhd Income Statement for year ended 31/12/2020 Sales Less: Cost of goods sold Gross profit Less: Expenses Profit before tax Less: Tax Profit after tax Less: Dividends To retained earnings Ratios Current ratio Acid-test ratio Debt ratio Average collection period Inventory turnover Return on total assets Gross profit margin Net profit margin General and administrative Interest Depreciation Total Table 2.1 Industry Norm 1.8 times 0.9 times 0.5 20 days 7 times 8.40% 25% 7.00% Table 2.2 50,000 10,000 30,000 700,000 500,000 200,000 END OF QUESTIONS. 90,000 110,000 27,100 82,900 31,800 51,100 ELLAN Team Sdn Bhd Calculate the financial ratios for 2019 and 2020 corresponding to the industry norms (Table 2.2). Provide comments for each ratio. State the strength and weaknesses of your analysis on AIFAZ Team Sdn. Bhd financial ratios. Advise whether to grant the loan or otherwise.
Expert Answer:
Answer rating: 100% (QA)
Task 1 There are a few steps that can be taken in order to obtain the best use of feedback from the budget Firstly it is important to ensure that the budget is realistic and achievable If the budget i... View the full answer
Related Book For
Introductory Statistics Exploring the World Through Data
ISBN: 978-0321978271
2nd edition
Authors: Robert Gould, Colleen Ryan
Posted Date:
Students also viewed these accounting questions
-
Required: 1. Prepare common-size comparative income statements for the two years for Beach Motors (Pty) Ltd. (11) 2. What observations can you make about the common-size statements? List at least...
-
Problem-4: An inverted hollow container with a uniform cross section area, A and height, H is slowly pushed into water as shown. The water rises into the container by a distance l (and compresses the...
-
Sam Ltd purchased 92% of the issued shares(Ex div)of Rex Ltd for $1404000 on 1 July 2019 when the equity of Rex Ltd was as follows; Share capital Asset revaluation surpluss Retained earnings 210600...
-
The investment cost of the project to launch a new production line is 200 million rubles; the revenue from the sale of new products manufactured using this line is 80 million rubles a year (before...
-
Refer to Exercise 15.37. a. Does a residual analysis support the conditions necessary to conduct your tests in Exercise 15.37? b. Conduct an analysis of the data, assuming that the normality...
-
Have students keep a diary listing their highest and lowest involvement product purchases or service transactions for each day for a week. Have them identify the decision process they went through...
-
Repeat the solution of Problem 12 for the case when the flow is unsteady and the problem is solved using the fully implicit time discretization (the simple implicit scheme).
-
Wood-Mode Company is involved in the design, manufacture, and installation of various types of wood products for large construction projects. Wood-Mode recently completed a large contract for Stadium...
-
answer for this. 13. With your chosen research problem, formulate the general objective consistent with the pattern given by Creswell and Clark [2014]. 1Write your answers on your notebook. [10...
-
Selected transactions completed by Equinox Products Inc. during the fiscal year ended December 31, 2014, were as follows: a. Issued 15,000 shares of $20 par common stock at $30, receiving cash. b....
-
To maintain a circular disc at 1000 K, an electrical heater supplies heat from the backside. The disc is positioned coaxially to a conical shape having the same outer diameter as 0.6 meters. The...
-
You are the chief internal auditor for Corbault Corporation, a large decentralized, diversified, manufacturing organization. As a result of concerns about controls over hardware and software...
-
Finerfoods, Inc., is a large, decentralized and diversified organization that primarily manufactures and sells grocery items. Various divisions of the company are widely dispersed geographically. In...
-
The vice president of production has requested that top management have the information systems division investigate the feasibility of a computer system to improve the scheduling of production....
-
Alfonza Company sells chairs that are used at computer stations. Its beginning inventory of chairs was 100 units at \(\$ 40\) per unit. During the year, Alfonza made two batch purchases of this...
-
Berryhill Co. started the year with no inventory. During the year, it purchased two identical inventory items at different times. The first purchase cost \(\$ 750\) and the other, \(\$ 1,000\)....
-
In Chapter 10 (Whalen), you learn the process for forecasting financial statements. make a forecasted income statement for your business gps tracking system. Answer the following questions: How did...
-
Ex. (17): the vector field F = x i-zj + yz k is defined over the volume of the cuboid given by 0x a,0 y b, 0zc, enclosing the surface S. Evaluate the surface integral ff, F. ds?
-
Find the geometric mean for the numbers 10, 100, and 1000 by following these steps: a. Find the log (base10) of each number: 10, 100, and 1000 b. Average the four resulting values. c. Find the...
-
Statistics student Hector Porath wanted to find out whether gender and the use of turn signals when driving were independent. He made notes when driving in his truck for several weeks. He noted the...
-
The table shows a random sample of 50 quantitative SAT scores of first-year students admitted at a university. Make an appropriate graph of the distribution of the data, and describe the...
-
Christian is owed \(\$ 180\) from his friend Chanel, but owes his friend Jeff \(\$ 91\). What is Christian's net worth?
-
Use your calculator to calculate \(19+(-36)\). Explain how the answer agrees with what was expected.
-
Use your calculator to calculate (-116)/4. Explain how the answer agrees with what was expected.
Study smarter with the SolutionInn App