Kopitano is a startup a coffee shop. Assist Kopitano in preparing the cash budget from June...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kopitano is a startup a coffee shop. Assist Kopitano in preparing the cash budget from June to September. The company has projected sales and expenses as follows: Month June July August September Sales (RM) Expenses Rentals Utilities 55,000 58,500 79,000 80,000 Historically, 30 percent of sales have been for cash and the remaining 70 percent are collected one month after sale. Depreciation Wages Purchases (RM) 40,000 55,000 58,000 45,000 60 percent of the purchase price is paid in cash and the balance 40 percent of the purchase price will be paid on month later. Fixed monthly expenses for Kopitano are: RM 4,000 2,800 8,000 2,500 In June, Kapitano expects to receive a RM5,000 dividend from its investment in a local mutual fund, while in August, Kapitano plans to renew its insurance policy and has to pay RM5,000 for that purpose. Kapitano also plans to pay its tax amounted RM3,000 in July and bonus will be pay in September, RM7,500. Kapitano's cash balance as at June was RM20,000 and a minimum of RM15,000 must be maintained at all times. Kapitano's borrowing subjected to 24 percent per annum interest rate. Prepare a complete financial planning for the months of July, August and September Kopitano. Kopitano is a startup a coffee shop. Assist Kopitano in preparing the cash budget from June to September. The company has projected sales and expenses as follows: Month June July August September Sales (RM) Expenses Rentals Utilities 55,000 58,500 79,000 80,000 Historically, 30 percent of sales have been for cash and the remaining 70 percent are collected one month after sale. Depreciation Wages Purchases (RM) 40,000 55,000 58,000 45,000 60 percent of the purchase price is paid in cash and the balance 40 percent of the purchase price will be paid on month later. Fixed monthly expenses for Kopitano are: RM 4,000 2,800 8,000 2,500 In June, Kapitano expects to receive a RM5,000 dividend from its investment in a local mutual fund, while in August, Kapitano plans to renew its insurance policy and has to pay RM5,000 for that purpose. Kapitano also plans to pay its tax amounted RM3,000 in July and bonus will be pay in September, RM7,500. Kapitano's cash balance as at June was RM20,000 and a minimum of RM15,000 must be maintained at all times. Kapitano's borrowing subjected to 24 percent per annum interest rate. Prepare a complete financial planning for the months of July, August and September Kopitano.
Expert Answer:
Answer rating: 100% (QA)
Kopitano A cash budget is a document produced to help a business manage their cash flow A cash budge... View the full answer
Related Book For
Cost Management Measuring Monitoring and Motivating Performance
ISBN: 978-0470769423
2nd edition
Authors: Leslie G. Eldenburg, Susan K. Wolcott
Posted Date:
Students also viewed these finance questions
-
A Finance Department of Everlasting Company is required to prepare a cash budget for the second quarter of 2022. The following are several information and assumptions in preparing the cash budget...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the...
-
Identify how balance sheet quality and earnings quality were impaired in each of the following accounting scandals: Waste Management 1988 - Falsely increased the useful lives of long-lived tangible...
-
Carbon dioxide at 15 MPa is injected into the top of a 5-km deep well in connection with an enhanced oil-recovery process. The fluid column standing in the well is at a uniform temperature of...
-
You have been asked to prepare a quick estimate of the construction cost for a coal-fired electricity generating plant and facilities. A work breakdown structure (levels one through three) is shown...
-
What advantages do residual income and EVA have over ROI for segment evaluations?
-
Petah, Ltd., of Tel Aviv, Israel, has budgeted costs in its various departments as follows for the coming year: Factory Administration . . . . . . . . . . . . . . . 540,000 Custodial Services . . . ....
-
PART A-Starting partnerships and dividing income On January 1, 2022, Steve Pippy and Mark Furlong agreed to pool their assets and form a partnership called F&P Consulting. They agree to share all...
-
Mirza Manufacturing makes four electronic products, each of which comprises three main materials: magnet, wiring, and casing. The products are shipped to three distribution centers in North America,...
-
Bulldog Company's inventory records report the following in October of the current year: Beginning First Purchase Second Purchase Date October 1 October 2 October 12 Units and Cost per Unit 5 units @...
-
a. Under what circumstances may it be advantageous to test controls with the computer? b. What are the disadvantages of auditing through the computer?
-
State the audit objectives for expenditure cycle transactions and balances that relate to each financial statement assertion category.
-
a. Under what circumstances may it not be necessary to confirm accounts receivable? b. What factors should be considered in determining the form of the confirmation request? c. When positive...
-
a. Identify the functions pertaining to sales adjustments transactions. b. State three types of controls pertaining to sales adjustments transactions and identify their common focus.
-
For each function pertaining to cash disbursements transactions, indicate the applicability, if any, of (a) proper authorization (b) independent checks.
-
Suppose 10-year T-bonds have a yield of 4.50% and 10-yearcorporate bonds yield 7.30%. Also, corporate bonds have a 0.25%liquidity premium versus a zero liquidity premium for T-bonds, andthe maturit 2...
-
Construct a 4 x 25 design confounded in two blocks of 16 observations each. Outline the analysis of variance for this design.
-
Axel Corporaton is planning to buy a new machine with the expectation that this investment should earn a rate of return of at least 15%. This machine, which costs $150,000, would yield an estimated...
-
Maine Lobster Company is a privately held company that buys lobsters from local fishermen and then delivers them to restaurants in several of Maines larger cities. The owners use variable costing...
-
A neighbor asked for your help preparing a grant for a not-for-profit after-school art program that would benefit elementary school children in the neighborhood. He wants to charge low fees for most...
-
Identify possible causes for (1) a favorable materials price variance; (2) an unfavorable materials price variance; (3) a favorable materials quantity variance; and (4) an unfavorable materials...
-
Standard cost variances can usually be broken down into two basic types of variances. Identify and describe these two types of variances.
-
Explain the net sales volume variance and list its components.
Study smarter with the SolutionInn App