Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Privacy Security Auditing Includes HIPAA Regulatory Compliance

Authors: Arup Nanda, Donald K Burleson

2nd Edition

0991638697, 978-0991638697

More Books

Students also viewed these Accounting questions

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago

Question

Influences on Nonverbal Communication?

Answered: 1 week ago