ALMA.com is an e-commerce service for teenagers' video games, television programs, and other material, intended to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ALMA.com is an e-commerce service for teenagers' video games, television programs, and other material, intended to be both educational and enjoyable. Valuable product information and detailed review comments are combined with a wide selection of products for purchase to help families make their children's educational and entertainment decisions. A team of leading educators and experts provide reviews and comments on the products sold by the firm. ALMA.com targets highly educated, convenience- oriented, and value-conscious families with children under the age of fifteen, estimated to be about 40 percent of Internet users. The firm is using a warehouse distribution model and channels that stems higher net margins, as well as greater selection and convenience for customers, when compared to traditional retailers and competitors. Venture capital of $1M was obtained to start up operations in 2020; a second round of venture financing of $0.14M (capital lease of warehouse facilities) helped ALMA.com to move through its survival stage. Because of relatively high marketing expenditures aimed at gaining market share, the firm is expected to suffer net losses for the first two years 2020 and 2021. However, net profit margins are expected to average 12% per year beginning in Year 2022. The management team is headed by Ms. Alma Serah, who serves as the president of the venture and controls about 35% of the ownership of the firm. Ms. Serah has more than twenty years of experience in high-tech industries, including previous positions with prestigious corporations such as Microsoft. She holds a Bachelor Degree in Electrical Engineering and a Master Degree in Computer Engineering from top educational institutions in the world. Nelma Bradman, director of technology, has more than twelve years of experience in software development and integration. Dalma Loman has almost ten years of experience in business development and sales in the software industry. Salma Norman, director of marketing, was responsible for the marketing communications function and the Internet operations of a large software company for nine years. Management strives for continual improvement in ease of user interface, personalized services, and amount of information supplied to customers. ALMA.com balance sheet as of the end of 2020 is expected to be as follows: ALMA.com Balance Sheet as of December 31, 2020 (In Millions) 0.15 0.47 0.55 0.14 $1.31 Cash Accounts receivable Inventories Net fixed assets* Total assets Accounts payable Capital Lease Liability* Total Liabilities Equity Total Liabilities and Equity *Represents the capital lease of tools and equipment (warehouse facilities) Quarter Q1 Q2 Q3 Q4 Total After discussions with the company's marketing manager and finance manager, sales over each quarter of 2021 are forecasted to be: Sales Forecast (in Millions) $ 0.50 $ 0.75 $ 0.85 0.17 0.14 0.31 1.00 $1.31 $0.90 $ 3.00 All sales are made on credit terms of net 90 days and are collected the following quarter. No bad debts are anticipated. The accounts receivable on the balance sheet at the end of 2020 thus will be collected in Quarter 1, 2021. Quarter 1, 2021 sales will be collected in Quarter 2, and so on. Inventory on hand represents a minimum operating level (safety stock), which the company intends to maintain. ALMA.com's policy is to maintain ending inventory at the end of each quarter equals to 30% of next quarter's expected sales. Purchases are paid 60% in the same quarter and 40% in the next quarter. Cost of goods sold averages 70% of sales (gross profit margin 30%). General, Administration and Selling cash expenses average 10% of sales. Depreciation is $0.01M per Quarter. The annual interest rate on outstanding lease liability is 5%. Interest expense is paid quarterly. Ms Alma Serah assumes taxes are paid quarterly and the income tax rate is 40% for budgeting purposes. The capital lease installment is 0.08M per Year (0.02 per quarter). There are no additional capital expenditures planned during 2021, and no equity payouts will be paid. The company's desired end-of- quarter minimum cash balance is $0.15M. Ms Serah hopes to meet any cash shortages during the period by an agreed $0.15M open line of credit with the bank at 4%. a. Prepare quarterly purchase budget for Q1, Q2, Q3, and for Q4 ending December 31, 2021 Assume that forecasted sales for the first quarter of 2022 = $1.2 million. b. Prepare quarterly general, administration and selling budget for Q1, Q2, Q3, and for Q4 ending December 31, 2021. c. Prepare quarterly cash budget for Q1, Q2, Q3, and for Q4 ending December 31, 2021. d. Prepare the pro forma income statement for the year ending December 31, 2021. e. Prepare the end of the year 2021 pro forma balance sheet. f. Based on your projections for the four quarters of 2021, indicate (1) whether new bank borrowing (open line of credit) will be needed and (2) if borrowing is needed, when does the need start occurring and what is the maximum amount needed? g. An analysis of the cash conversion cycle should also help Alma Serah understand what has been happening to the operations of ALMA.com. Prepare an analysis of the conversion periods for the three components of the cash conversion cycle for 2021. Explain what has happened in terms of each component of the cycle during 2021. Ms. Serah should be interested in knowing whether ALMA.com. has been building or burning cash. Comment on the cash build, cash burn, and the net cash build/burn position for 2021. Ms. Alma Serah is planning to leverage equity capital with debt during the years 2022, 2023 and 2024. She is keen to know whether ALMA.com will add economic value. Therefore, in order to assess the effects of its leveraging debt strategy, ALMA.com prepared a projected Statement of Financial Position (Balance Sheet) and Income Statement for the years 2022, 2023 and 2024 based on certain assumptions and events that are likely to happen in the future. The interest rate on capital lease is 5%. The average expected interest rate on the bank loan during 2022 - 2024 is 4%. For long-term debt, the real interest rate is estimated to be 3%; the inflation premium is 4%; and ALMA.com's default/liquidity risk premium over government bonds is estimated to be 5%. The cost of common equity was estimated using the risk-free long-term government bond rate plus investment risk premium of 5.8%. The income tax rate = 40%. Following are the projected statements of income and financial position for 2022, 2023 and 2024: Alma.com Projected Statement of Income (2022 - 2024) INCOME STATEMENT Revenues Cost of Goods Sold Gross Profit General and Marketing Expenses Research and Development Depreciation EBIT Interest Expense EBT Income Taxes Net Income (Loss) BALANCE SHEET Cash Accounts Receivable Inventories Total Current Assets Net fixed assets* Total Assets Accounts payable Accrued Liabilities Alma.com Projected Statement of Financial Position (2022 - 2024) Total Current Liabilities Capital Lease Liability* Bank Loan Long-Term Debt Total Non-Current Liabilities Total Liabilities Venture Capital Additional Paid-in Capital 2022 $3.44M 2.55 0.89 0.26 0.05 0.06 0.57 0.07 0.50 0.20 0.30 Retained Earnings Total Equity 2022 $ 1.15 M 0.35 0.50 2.00 0.15 2.15 0.44 0.16 0.60 0.13 0.12 2023 $7.50M 5.20 3.30 0.45 1.05 0.34 0.05 0.09 1.87 0.11 1.76 0.70 1.06 2023 $ 1.87 M 1.00 0.48 3.35 0.35 3.70 0.59 0.38 0.97 0.30 0.45 0.50 1.25 2.22 1.00 0.30 0.18 1.48 3.70 1.00 0 0.10 1.10 Total Liabilities and Equity 2.15 *Represents the capital lease of tools and equipment (warehouse facilities) 2024 $12.30M 8.72 3.58 0.36 0.05 0.12 3.05 0.18 2.87 1.15 1.72 2024 $ 3.95 M 1.50 1.40 6.85 0.57 7.42 1.13 0.52 1.65 0.60 0.70 50 2.80 4.45 1.00 0 1.97 2.97 7.42 h. Determine the financial structure weights from ALMA.com's 2024 statement of financial position for the three interest-bearing debt components and the common equity. i. Calculate ALMA.com's weighted average cost of capital (WACC) j. Estimate ALMA.com's economic value added (EVA). Did ALMA.com expect to build or destroy economic value in 2024? [Hint: Consider whether ALMA.com is adding economic value in terms of its net operating profit after taxes (NOPAT)* and its weighted average cost of capital (WACC). k. Alma.com investors have been approached by an outside investor who wants to invest $3.0M in the venture at the end of 2020. What percentage of ownership in the venture should ALMA.com investors give up to the outside investor for a $3.0M new investment? Alma.com financial analysts predict that Operating Cash Flows are expected to be $0.21M in 2021, $0.55M in 2022, $0.60M in 2023 and $76M in 2024. The analysts further predict that the company's cash flows are expected to grow at 1% annual rate indefinitely beyond 2024. [Hint: Use Projected Free Cash Flow]. 3 ALMA.com is an e-commerce service for teenagers' video games, television programs, and other material, intended to be both educational and enjoyable. Valuable product information and detailed review comments are combined with a wide selection of products for purchase to help families make their children's educational and entertainment decisions. A team of leading educators and experts provide reviews and comments on the products sold by the firm. ALMA.com targets highly educated, convenience- oriented, and value-conscious families with children under the age of fifteen, estimated to be about 40 percent of Internet users. The firm is using a warehouse distribution model and channels that stems higher net margins, as well as greater selection and convenience for customers, when compared to traditional retailers and competitors. Venture capital of $1M was obtained to start up operations in 2020; a second round of venture financing of $0.14M (capital lease of warehouse facilities) helped ALMA.com to move through its survival stage. Because of relatively high marketing expenditures aimed at gaining market share, the firm is expected to suffer net losses for the first two years 2020 and 2021. However, net profit margins are expected to average 12% per year beginning in Year 2022. The management team is headed by Ms. Alma Serah, who serves as the president of the venture and controls about 35% of the ownership of the firm. Ms. Serah has more than twenty years of experience in high-tech industries, including previous positions with prestigious corporations such as Microsoft. She holds a Bachelor Degree in Electrical Engineering and a Master Degree in Computer Engineering from top educational institutions in the world. Nelma Bradman, director of technology, has more than twelve years of experience in software development and integration. Dalma Loman has almost ten years of experience in business development and sales in the software industry. Salma Norman, director of marketing, was responsible for the marketing communications function and the Internet operations of a large software company for nine years. Management strives for continual improvement in ease of user interface, personalized services, and amount of information supplied to customers. ALMA.com balance sheet as of the end of 2020 is expected to be as follows: ALMA.com Balance Sheet as of December 31, 2020 (In Millions) 0.15 0.47 0.55 0.14 $1.31 Cash Accounts receivable Inventories Net fixed assets* Total assets Accounts payable Capital Lease Liability* Total Liabilities Equity Total Liabilities and Equity *Represents the capital lease of tools and equipment (warehouse facilities) Quarter Q1 Q2 Q3 Q4 Total After discussions with the company's marketing manager and finance manager, sales over each quarter of 2021 are forecasted to be: Sales Forecast (in Millions) $ 0.50 $ 0.75 $ 0.85 0.17 0.14 0.31 1.00 $1.31 $0.90 $ 3.00 All sales are made on credit terms of net 90 days and are collected the following quarter. No bad debts are anticipated. The accounts receivable on the balance sheet at the end of 2020 thus will be collected in Quarter 1, 2021. Quarter 1, 2021 sales will be collected in Quarter 2, and so on. Inventory on hand represents a minimum operating level (safety stock), which the company intends to maintain. ALMA.com's policy is to maintain ending inventory at the end of each quarter equals to 30% of next quarter's expected sales. Purchases are paid 60% in the same quarter and 40% in the next quarter. Cost of goods sold averages 70% of sales (gross profit margin 30%). General, Administration and Selling cash expenses average 10% of sales. Depreciation is $0.01M per Quarter. The annual interest rate on outstanding lease liability is 5%. Interest expense is paid quarterly. Ms Alma Serah assumes taxes are paid quarterly and the income tax rate is 40% for budgeting purposes. The capital lease installment is 0.08M per Year (0.02 per quarter). There are no additional capital expenditures planned during 2021, and no equity payouts will be paid. The company's desired end-of- quarter minimum cash balance is $0.15M. Ms Serah hopes to meet any cash shortages during the period by an agreed $0.15M open line of credit with the bank at 4%. a. Prepare quarterly purchase budget for Q1, Q2, Q3, and for Q4 ending December 31, 2021 Assume that forecasted sales for the first quarter of 2022 = $1.2 million. b. Prepare quarterly general, administration and selling budget for Q1, Q2, Q3, and for Q4 ending December 31, 2021. c. Prepare quarterly cash budget for Q1, Q2, Q3, and for Q4 ending December 31, 2021. d. Prepare the pro forma income statement for the year ending December 31, 2021. e. Prepare the end of the year 2021 pro forma balance sheet. f. Based on your projections for the four quarters of 2021, indicate (1) whether new bank borrowing (open line of credit) will be needed and (2) if borrowing is needed, when does the need start occurring and what is the maximum amount needed? g. An analysis of the cash conversion cycle should also help Alma Serah understand what has been happening to the operations of ALMA.com. Prepare an analysis of the conversion periods for the three components of the cash conversion cycle for 2021. Explain what has happened in terms of each component of the cycle during 2021. Ms. Serah should be interested in knowing whether ALMA.com. has been building or burning cash. Comment on the cash build, cash burn, and the net cash build/burn position for 2021. Ms. Alma Serah is planning to leverage equity capital with debt during the years 2022, 2023 and 2024. She is keen to know whether ALMA.com will add economic value. Therefore, in order to assess the effects of its leveraging debt strategy, ALMA.com prepared a projected Statement of Financial Position (Balance Sheet) and Income Statement for the years 2022, 2023 and 2024 based on certain assumptions and events that are likely to happen in the future. The interest rate on capital lease is 5%. The average expected interest rate on the bank loan during 2022 - 2024 is 4%. For long-term debt, the real interest rate is estimated to be 3%; the inflation premium is 4%; and ALMA.com's default/liquidity risk premium over government bonds is estimated to be 5%. The cost of common equity was estimated using the risk-free long-term government bond rate plus investment risk premium of 5.8%. The income tax rate = 40%. Following are the projected statements of income and financial position for 2022, 2023 and 2024: Alma.com Projected Statement of Income (2022 - 2024) INCOME STATEMENT Revenues Cost of Goods Sold Gross Profit General and Marketing Expenses Research and Development Depreciation EBIT Interest Expense EBT Income Taxes Net Income (Loss) BALANCE SHEET Cash Accounts Receivable Inventories Total Current Assets Net fixed assets* Total Assets Accounts payable Accrued Liabilities Alma.com Projected Statement of Financial Position (2022 - 2024) Total Current Liabilities Capital Lease Liability* Bank Loan Long-Term Debt Total Non-Current Liabilities Total Liabilities Venture Capital Additional Paid-in Capital 2022 $3.44M 2.55 0.89 0.26 0.05 0.06 0.57 0.07 0.50 0.20 0.30 Retained Earnings Total Equity 2022 $ 1.15 M 0.35 0.50 2.00 0.15 2.15 0.44 0.16 0.60 0.13 0.12 2023 $7.50M 5.20 3.30 0.45 1.05 0.34 0.05 0.09 1.87 0.11 1.76 0.70 1.06 2023 $ 1.87 M 1.00 0.48 3.35 0.35 3.70 0.59 0.38 0.97 0.30 0.45 0.50 1.25 2.22 1.00 0.30 0.18 1.48 3.70 1.00 0 0.10 1.10 Total Liabilities and Equity 2.15 *Represents the capital lease of tools and equipment (warehouse facilities) 2024 $12.30M 8.72 3.58 0.36 0.05 0.12 3.05 0.18 2.87 1.15 1.72 2024 $ 3.95 M 1.50 1.40 6.85 0.57 7.42 1.13 0.52 1.65 0.60 0.70 50 2.80 4.45 1.00 0 1.97 2.97 7.42 h. Determine the financial structure weights from ALMA.com's 2024 statement of financial position for the three interest-bearing debt components and the common equity. i. Calculate ALMA.com's weighted average cost of capital (WACC) j. Estimate ALMA.com's economic value added (EVA). Did ALMA.com expect to build or destroy economic value in 2024? [Hint: Consider whether ALMA.com is adding economic value in terms of its net operating profit after taxes (NOPAT)* and its weighted average cost of capital (WACC). k. Alma.com investors have been approached by an outside investor who wants to invest $3.0M in the venture at the end of 2020. What percentage of ownership in the venture should ALMA.com investors give up to the outside investor for a $3.0M new investment? Alma.com financial analysts predict that Operating Cash Flows are expected to be $0.21M in 2021, $0.55M in 2022, $0.60M in 2023 and $76M in 2024. The analysts further predict that the company's cash flows are expected to grow at 1% annual rate indefinitely beyond 2024. [Hint: Use Projected Free Cash Flow]. 3
Expert Answer:
Answer rating: 100% (QA)
a To prepare the quarterly purchase budget for each quarter of 2021 and Q1 2022 we need to consider the forecasted sales desired ending inventory and the payment terms for purchases Heres the calculat... 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
-
HORSE RIDING REALTY COMPAMY BALANCE SHEET As of September 31, 2020 ASSETS LIABILITY $100,000 S50,000 $200,000 S160,000 S40,000 S8,000 $11,000 $9,000 Accounts Payable Wages Payable Note Payable 6%...
-
If a combination of goods is located above an economy's production possibility curve and above its consumption possibility curve, then: this combination of goods is attainable regardless of whether...
-
The Edwards Lake Community Hospital balance sheet as of December 31, 2019, follows. Required a. Record in general journal form the effect of the following transactions during the fiscal year ended...
-
The Chicago Omni Hotel is a 750-room luxury hotel offering guests the finest facilities in downtown Chicago. The hotel is organized into four departments: lodging, dining, catering, and retail...
-
Refer to the EDUCATION data set available at the books companion website. Use the following set of independent variablesPAFR, PHISP, CLASS, and TETURNto explain overall student pass rates, or...
-
In Exercises use the quotient Rule to find the derivative of the function. g(x) = sin x zr
-
If it is 4:00 now, what time was it 67 hours ago?
-
You work for Nokia in its global cell phone group. You have been made project manager for the design of a new cell phone. Your supervisors have already scoped the project so you have a list showing...
-
help, but I need to attach the second part of the question. Question 1: Diluted EPS - SHOW ALL CALCULATIONS (18 marks) Chrissy Corporation had the following securities outstanding at its fiscal year...
-
A process is in control with x = 100.s = 1.05, and n = 5. The process specifications are at 95 ± 10. The quality characteristic has a normal distribution. (a) Estimate the potential...
-
Electrical installation in a process plants is 60% of direct equipment costs. Process plants have a Lang factor of 4.6 (total construction)/(direct equipment). In 1987 a plant in Alabama, that...
-
Acme Incorporated manufactures anvils for use in iron molding. Information regarding their 2021 operating and production performance follows. Throughput Time 11 days Inspection Time 1 days Process...
-
Rewrite: Use what you have learned regarding academic and professional tools/resources and rewrite Terry's email message so that it is professional. Explain: In 100 words or more, explain 2-3 tools...
-
Dara's Deals, LLC uses accrual accounting. In January the company purchased 500 phone cases at a cost of $6.00 per case. During January the company sold 300 of the cases for $15.00 per case. All...
-
Writea650-to700-wordpaperonthesubjectofvisualarts,inwhichyoudefinethepurposeandlanguageofthevisualarts.Imaginethatyourpaperonvisualartsistobeincludedinauniversitywebsiteonarthistoryandartappreciationt...
-
3. We consider a motion of a projectile with air resistance. Let z be a horizontal coordinates z a vertical coordinate, the equation of motion is =-k(x) + (y') z mz" -k(x) + (y) ' - mg = where the...
-
An employer cannot use a salary reduction SEP unless _____ percent or more of the employees eligible to participate elect to make SEP contributions. Question 8 options: a) 25 b) 10 c) 75 d) 50
-
You are the newly appointed tax practitioner to complete Emilys tax return and have downloaded the prefill report for Emilys tax return (hint, you can read what a prefill report is here (Links to an...
-
The GASB is reexamining the financial reporting model for state and local governments. Consideration is being given to changes in the measurement focus and basis of accounting for governmental funds...
-
The City of Troy collects its annual property taxes late in its fiscal year. Consequently, each year it must finance part of its operating budget using tax anticipation notes. The notes are repaid...
-
The City of Castletons General Fund had the following post-closing trial balance at June 30, 2019, the end of its fiscal year: During the year ended June 30, 2020, the following transactions, in...
-
What would you think about a company whose stock was selling for \($50\) a share in January and \($12\) a share in December?
-
Because a publicly traded company receives money only when its stock is originally issued, why do you think it would care about the stocks market value in the stock market? Assume you own stock in a...
-
When you consider that companies are generally in business to earn a profit, why might it be acceptable to select a capital project that promises a return that is just equal to the weighted average...
Study smarter with the SolutionInn App