i need help please to do this

Tap to show outline 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, convenienceoriented, 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 retailersand competitors. Venture capital of $1M was obtained to start up operations in 2021; 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 2021 and 2022. However, net profit margins are expected to average 12% per year beginningin Year 2023. 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. Tap to show outline 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 2022, and no equity payouts will be paid. The company's desired end-ofquarter 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 creditwith the bank at 4%. a. Prepare quarterly purchase budget for Q1, Q2, Q3, and for Q4 ending December 31, 2022 Assume that forecasted salesfor the firstquarter of 2023 = $1.2 million b. Prepare quarterly general, administration and selling budget for 01, 02, 03, and for Q4 ending December31, 2022. c. Prepare quarterly cash budget for Q1, Q2, Q3, and for Q4 endingDecember 31, 2022. d. Prepare the pro forma income statement for the year ending December31, 2022. e. Prepare the end of the year 2022 pro forma balance sheet. f. Based on your projections for the four quarters of 2023, 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 maximumamount 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 2022. Explain what has happened in terms of each component of the cycle during 2022. 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 positionfor2022. Tap to show outline Ms. Alma Serah is planning to leverage equity capital with debt during the years 2023, 2024 and 2025. 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 2023, 2024 and 2025 based on certain assumptions and events that are likely tohappen inthe future. The interest rate on capital lease is 5%. The average expected interest rate on the bank loan during 2023-2025 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 riskpremiumof 5.8%. The income tax rate = 40% Followingare the projected statements of income and financial position for 2023,2024 and 2025 Alma.com Projected Statement of Income (2023-2025) 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) 2023 $3.44M 2.55 0.89 0.26 0.05 0.06 0.57 0.02 0.50 0.20 0.30 2024 57.5OM 5.20 3.30 0.34 0.05 2025 512 BOM 8.72 3.58 0.36 0.05 0.12 3.05 0.18 2.87 1.87 011 1.76 0.70 106 Alma.com Projected Statement of Financial Position (2023 - 2025) 2024 BALANCE SHEET ruh 2025 195 Tap to show outline Alma.com Projected Statement of Financial Position (2023 - 2025) 2024 5 1.87M 1.00 2025 S 3.95 M 1.50 140 6.85 0.52 7.42 335 0.35 2.70 0.59 BALANCE SHEET Cash Accounts Receivable Inventories Total Current Assets Net fored assets Total Assets Accounts payable Accrued Liabilities Total Current Liabilities Capital Lease Liability Bank Loan Long Term Debt Total Non-Current Liabilities Total Liabilities Venture Capital Additional Paid-in Capital Retained Earnings Total Equity Total Liabilities and Equity 2023 5 1.15 M 035 0.50 2.00 0.15 215 044 015 0.60 0.13 0.12 0.22 0.45 105 100 0 0.10 1.10 2.15 097 0.30 0.45 0.50 1.25 2222 1.00 0.30 018 1.48 3.70 0.52 1.65 0.60 0.70 1.50 2.80 4.45 1.00 0 197 2.97 7.42 h. Determine the financial structure weights from ALMA.com's 2025 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) 1. Estimate ALMA.com's economic value added (EVA). Did ALMA.com expect to build or destroy economic value in 2025? (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 2021. 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 2022. 50.55M in 2023, $0.60M in 2024 and $0.76M in 2025. The analysts further predict that the company's cash flows are expected to grow at 1% annual rate indefinitely Tap to show outline 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, convenienceoriented, 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 retailersand competitors. Venture capital of $1M was obtained to start up operations in 2021; 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 2021 and 2022. However, net profit margins are expected to average 12% per year beginningin Year 2023. 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. Tap to show outline 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 2022, and no equity payouts will be paid. The company's desired end-ofquarter 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 creditwith the bank at 4%. a. Prepare quarterly purchase budget for Q1, Q2, Q3, and for Q4 ending December 31, 2022 Assume that forecasted salesfor the firstquarter of 2023 = $1.2 million b. Prepare quarterly general, administration and selling budget for 01, 02, 03, and for Q4 ending December31, 2022. c. Prepare quarterly cash budget for Q1, Q2, Q3, and for Q4 endingDecember 31, 2022. d. Prepare the pro forma income statement for the year ending December31, 2022. e. Prepare the end of the year 2022 pro forma balance sheet. f. Based on your projections for the four quarters of 2023, 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 maximumamount 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 2022. Explain what has happened in terms of each component of the cycle during 2022. 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 positionfor2022. Tap to show outline Ms. Alma Serah is planning to leverage equity capital with debt during the years 2023, 2024 and 2025. 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 2023, 2024 and 2025 based on certain assumptions and events that are likely tohappen inthe future. The interest rate on capital lease is 5%. The average expected interest rate on the bank loan during 2023-2025 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 riskpremiumof 5.8%. The income tax rate = 40% Followingare the projected statements of income and financial position for 2023,2024 and 2025 Alma.com Projected Statement of Income (2023-2025) 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) 2023 $3.44M 2.55 0.89 0.26 0.05 0.06 0.57 0.02 0.50 0.20 0.30 2024 57.5OM 5.20 3.30 0.34 0.05 2025 512 BOM 8.72 3.58 0.36 0.05 0.12 3.05 0.18 2.87 1.87 011 1.76 0.70 106 Alma.com Projected Statement of Financial Position (2023 - 2025) 2024 BALANCE SHEET ruh 2025 195 Tap to show outline Alma.com Projected Statement of Financial Position (2023 - 2025) 2024 5 1.87M 1.00 2025 S 3.95 M 1.50 140 6.85 0.52 7.42 335 0.35 2.70 0.59 BALANCE SHEET Cash Accounts Receivable Inventories Total Current Assets Net fored assets Total Assets Accounts payable Accrued Liabilities Total Current Liabilities Capital Lease Liability Bank Loan Long Term Debt Total Non-Current Liabilities Total Liabilities Venture Capital Additional Paid-in Capital Retained Earnings Total Equity Total Liabilities and Equity 2023 5 1.15 M 035 0.50 2.00 0.15 215 044 015 0.60 0.13 0.12 0.22 0.45 105 100 0 0.10 1.10 2.15 097 0.30 0.45 0.50 1.25 2222 1.00 0.30 018 1.48 3.70 0.52 1.65 0.60 0.70 1.50 2.80 4.45 1.00 0 197 2.97 7.42 h. Determine the financial structure weights from ALMA.com's 2025 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) 1. Estimate ALMA.com's economic value added (EVA). Did ALMA.com expect to build or destroy economic value in 2025? (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 2021. 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 2022. 50.55M in 2023, $0.60M in 2024 and $0.76M in 2025. The analysts further predict that the company's cash flows are expected to grow at 1% annual rate indefinitely