Question
According to the following information, develop the entire financial process requested. A small company that is owned by Ms. Lola Ment with identification number 102457894-7,
According to the following information, develop the entire financial process requested. A small company that is owned by Ms. Lola Ment with identification number 102457894-7, wishes to establish a process of expansion of its production and also develop the entire financial and business legalization process. The company manufactures and sells hats for people with alopecia (baldness), it presents the following assets: Warehouse owned by Ms. $6,568,214 Machinery for production $4,001,002 Computer equipment $2,200,001 Furniture and fixtures $1,210,147 Sales are as follows PRODUCT UNIT COST EXPECTED PROFIT SALE PRICE UNITS SOLD MONTHLY Cap A $2,521 35% 2,500 Cap B $1,745 20% 2,300 Cap C $1,969 24% 1069 Bills: 3 workers each with a SMLV and transportation subsidy. 1 administrator with a salary of $1,800,000, average SSP $136,000, rent $850,000, monthly purchase of raw materials $1,800,000, various supplies $300,000 To develop your expansion plan, you must acquire a loan with a reinsurer for a value of $50,000,000 at an annual interest rate of 13.55% for 48 months. Scenario 1: Sales are the same in the same cash flow month, 45% of the company's total assets will be used, expenses will be the same. Scenario 2: Sales decrease by 4%, 55% of the company's total assets will be used, expenses will increase by 2%. Scenario 3: Sales decrease by 0.5%, 65% of the company's total assets will be used, expenses remain the same. Scenario 4: Sales increase by 2.5%, 75% of the company's total assets will be used, expenses remain the same. Calculate: 1. Cash flow according to the number of scenarios. 2. Amortization to establish the expansion. 3. Calculation of ROE, ROA and leverage.
Append processes in Excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started