Prepare quarterly purchase budget

Assignment Help Finance Basics
Reference no: EM133096057 , Length: word count:700

CASE STUDY: ALMA

Prepare quarterly purchase budget for Q1, Q2, Q3, and for Q4 ending December 31, 2022 Assume that forecasted sales for the first quarter of 2023 = $1.20 million.

Prepare quarterly general, administration and selling budget for Q1, Q2, Q3, and for Q4 ending December31, 2022.

Prepare quarterly cash budget for Q1, Q2, Q3, and for Q4 ending December 31, 2022.

Prepare the pro forma income statement for the year ending December 31, 2022.

Prepare the end of the year 2022 pro forma balance sheet.

Based on your projections for the four quarters of 2022, 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?

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 annual expected operating and cash conversion periods (cycles) 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 position for2022.

Attachment:- Case Study - Alma.rar

Reference no: EM133096057

Questions Cloud

Personality development as a leader : As civil engineer, describe an example where you have shown or apply your leadership skills , ability , strategy etc. and that it results to a positive impact i
What are accounting entries required to record these events : The 4 million shares are allotted on 5 Feb 2019. What are the accounting entries required to record these events
Why is training important during onboarding : Why is training important during onboarding? Why is in-person orientation/onboarding better?
Compute present value of lease payments for lessee : Three lease payments of 552,044 are to be made at the end of each year, Compute the present value of lease payments for Lessee Corporation on January 1, 2019
Prepare quarterly purchase budget : Prepare quarterly general, administration and selling budget for Q1, Q2, Q3, and for Q4 ending December31, 2022
Concept of permanent employment : Employees are showing far less loyalty now that the concept of "employability," which has replaced the concept of permanent employment, has been introduced into
Define strategic alignment : 1. Define strategic alignment? 2. Define competitive strategy.? 3. Define strategic human resources development?
Managers in healthcare organizations : As healthcare managers, what do you see as the greatest challenge facing managers in healthcare organizations? How do we overcome those challenges?
Disease of musculoskeletal system : Describe a major disease of the musculoskeletal system and the most common tests used to diagnose the disease.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd