On 1 April 2020, Kimin is attempting to budget cash flows through 30 June 2020. On...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
On 1 April 2020, Kimin is attempting to budget cash flows through 30 June 2020. On this latter date, the principal of a secured bank loan, $5 million, will be payable. This bank loan was secured at 3.5% per annum. Cash Interest payment on this loan are settled monthly. An interim cash dividend of $6 million will be due end of June. The company only transact on credit sales. A discount of 6% is given to all customers who pay within one month. 70% of the accounts receivable will be received in the month of sale. 20% will be collected in the following month, and the remaining will be received in the month after next. There is a 5% provision for bad debt for accounts receivable in the month after the next. Projected and Actual Sales are: January February March April May June Projected Sales ($) July For the Year ending 31 Dec 15 600 000 15 600 000 17 600 000 18 200 000 17 500 000 16 600 000 15 500 000 200 000 000 January February March April May June Opening cash balance as at 1 April is $25 500 000 Actual Sales ($) July For Year to Date 15 850 000 16 450 000 17 280 000 49 580 000 Purchases are made on basis of 70% the following month's projected sales. 50% of the purchases are paid for in the month of purchase, and a 5% prompt settlement discount is received. The remainder is paid in full the following month. Total budgeted fixed operating expenses for the year are $40 million Fixed costs are accrued evenly through the year. The operating variable costs is determined to be 10% of that month's projected purchases, which accrued evenly with purchases. Both fixed and variable operating expenses are paid in the month incurred. Requirements: You will be required to write a management report in which the following points should be discussed. Analyse the Investment proposals by using NPV and IRR and provide recommendations. You should also briefly comment on other investment proposal techniques that Kimin may use, and the limitations of using these techniques. ● ● Provide an explanation on the different sources of funding available to the company, and their advantages and disadvantages and make recommendations as to how these funding sources are appropriate to the planned investment project. Analyse the level of breakeven required if Kimin proceeds with the investment. Prepare a forecasted cash budget for April to June 2020. An evaluation of Kimin's performance or position during the same period. A detailed Literature Review of the tools you have used such as capital investment techniques, breakeven analysis and budgets and their importance to the business case. Other issues for management to consider that you think are vital for them to survive and make a profit. On 1 April 2020, Kimin is attempting to budget cash flows through 30 June 2020. On this latter date, the principal of a secured bank loan, $5 million, will be payable. This bank loan was secured at 3.5% per annum. Cash Interest payment on this loan are settled monthly. An interim cash dividend of $6 million will be due end of June. The company only transact on credit sales. A discount of 6% is given to all customers who pay within one month. 70% of the accounts receivable will be received in the month of sale. 20% will be collected in the following month, and the remaining will be received in the month after next. There is a 5% provision for bad debt for accounts receivable in the month after the next. Projected and Actual Sales are: January February March April May June Projected Sales ($) July For the Year ending 31 Dec 15 600 000 15 600 000 17 600 000 18 200 000 17 500 000 16 600 000 15 500 000 200 000 000 January February March April May June Opening cash balance as at 1 April is $25 500 000 Actual Sales ($) July For Year to Date 15 850 000 16 450 000 17 280 000 49 580 000 Purchases are made on basis of 70% the following month's projected sales. 50% of the purchases are paid for in the month of purchase, and a 5% prompt settlement discount is received. The remainder is paid in full the following month. Total budgeted fixed operating expenses for the year are $40 million Fixed costs are accrued evenly through the year. The operating variable costs is determined to be 10% of that month's projected purchases, which accrued evenly with purchases. Both fixed and variable operating expenses are paid in the month incurred. Requirements: You will be required to write a management report in which the following points should be discussed. Analyse the Investment proposals by using NPV and IRR and provide recommendations. You should also briefly comment on other investment proposal techniques that Kimin may use, and the limitations of using these techniques. ● ● Provide an explanation on the different sources of funding available to the company, and their advantages and disadvantages and make recommendations as to how these funding sources are appropriate to the planned investment project. Analyse the level of breakeven required if Kimin proceeds with the investment. Prepare a forecasted cash budget for April to June 2020. An evaluation of Kimin's performance or position during the same period. A detailed Literature Review of the tools you have used such as capital investment techniques, breakeven analysis and budgets and their importance to the business case. Other issues for management to consider that you think are vital for them to survive and make a profit.
Expert Answer:
Answer rating: 100% (QA)
The investment proposals are as follows 1 The purchase of new machinery which will cost 10 million This machinery will have a 4year life and it is expected to generate savings of 25 million per year i... View the full answer
Related Book For
Accounting for Governmental and Nonprofit Entities
ISBN: 978-1259917059
18th edition
Authors: Jacqueline L. Reck, James E. Rooks, Suzanne Lowensohn, Daniel Neely
Posted Date:
Students also viewed these accounting questions
-
The principal of a charter school in Tampa believes that the IQs of its students are above the national average of 100. From the past experience, IQ is normally distributed with a standard deviation...
-
You are chatting with the principal of a local high school. The topic of SAT scores comes up, and the principal mentions that SAT scores at the school are normally distributed. She doesn't remember...
-
Refer to E6.17. If Kallsen gives customers who pay within the month of sale a 2 percent discount, does this change your answer? Why?
-
Give a recursive algorithm for finding the reversal of a bit string. (See the definition of the reversal of a bit string in the preamble of Exercise 34 in Section 5.3.)
-
On the basis of the following data, for Teller Co. for 2006 and the preceding year ended December 31, 2005, prepare a statement of cash flows in excel. Use the indirect method of reporting cash flows...
-
Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for...
-
The balance sheet data for Quick Care, Inc. September 30, 2010, follow: Requirement 1. The following are three independent assumptions about the business during September. For each assumption,...
-
The weighted average cost of capital for a firm (assuming all three Modigliani and Miller assumptions apply) is 15 percent. What is the current cost of equity capital for the firm if its cost of debt...
-
(a) What is a firm's strategic policy? How, if at all, does it influence a firm's choice of capital budgeting projects? (b) What is an "unbiased" cash flow forecast? Do you find it surprising that...
-
Determining the sensitivity of a banks profits to changing interest rates is an example of which type of financial analytics? a. Prescriptive analytics b. Descriptive analytics c. Diagnostic...
-
Savor the Sweet Bakery has been selling 550 boxes of cupcakes per month at a price of $19/box. When they raised their price to $21/box, they sold only 450 boxes. 1)What is the price elasticity of...
-
2. The diagram below shows a fenced area. The enclosure has a rectangular portion connected to a semi-circular portion as shown. The cost to build and install the fence is $26/ft for the curved...
-
The average person making minimum wage earns about $1,100 per month after taxes. Using this amount, give me a realistic budget of your expenditures for each category. You have to stick to this...
-
2. Consider the image segment shown in the figure that follows. As in Section 2.5, let V = {0,1} be the set of intensity values used to define adjacency. Compute the lengths of the shortest 4-, 8-,...
-
Exhale ( Pty ) Ltd engages in the manufacture and retail of luxurious, scented diffusers. The company started its operations 5 years ago when Anne Apple saw a need in the market for personal care...
-
Respond to the following scenario. Fully discuss your solution with substantiation. Post your exam here and discuss your findings with your classmates in the discussion area. You will not be able to...
-
Despite being the country that has emitted the most emissions into the atmosphere since the Industrial Revolution, in 2020 the U.S. (under President Trump) ____________ the Paris Climate Agreement,...
-
What are multinational corporations (MNCs) and what economic roles do they play?
-
The Kyle Sports Medicine facility is a not-for-profit health care facility that is trying to determine what transaction information should be included in its calculation of the performance indicator...
-
Utilizing the annual report obtained for Exercise 117, follow these instructions: a. Custodial Funds. Note that depending on the CAFR fiscal year, agency funds rather than custodial funds may be...
-
Bluff Countys schedule of changes in net pension liability and related ratios is shown below. Required Compute the missing amounts. BLUFF COUNTY EMPLOYEE RETIREMENT SYSTEM Schedule of Changes in the...
-
A ___________ chart is a histogram that can help you identify and prioritize problem areas. A. Pareto B. control C. run D. scatter
-
What are the Seven Basic Tools of Quality? If applicable, describe how you have you used these tools in the workplace.
-
Perform the monitoring and controlling tasks for one of the case studies provided in Appendix C. If you are working on a real team project, create relevant monitoring and controlling documents, such...
Study smarter with the SolutionInn App