Name: E-Mail: Cell Phone Number:: Balance Sheet Initial 1st Month

Emiliano Mancilla
Name:
E-mail: cemilianoms@gmail.com
7221318009
Cell phone number:
I. You’ve created a shoe company. The total investment to develop this enterprise was US$200 million, 75% was a capital contribution and
the balance came from a 5-year bank loan (which is amortized at maturity). US$150 million were required to build the shoe factory and
show room, and US$40 million were invested on the shoe inventory.
1) Build the initial balance sheet of the company (Initial balance column)
On your first month of operations you sell US$10 million, 50% to individual clients, who paid in cash, and 50% to a large department store
that agreed to pay you 3 months from now.
2) Consider a gross margin of 25%, no additional expenses, no tax payment, a 12% annual interest rate (paid monthly) for the 5-year
bank loan, and no interest gains on cash equivalents. Report the company’s first month P&L statement and balance sheet.
Balance Sheet
Initial 1st Month
Cash 10,000,000 7,000,000
Inventory 40,000,000 40,000,000
Account receivables 0 5,000,000
Current Assets 50,000,000 52,000,000

Fixed Assets 150,000,000 150,000,000
Total Assets 200,000,000 202,000,000
Cost Bearing Liabilities 0 0

Accounts Payables 0 0
Long -term cost bearing debt 50,000,000 50,000,000
Total Liabilities 50,000,000 50,000,000
Equity
Profit and Losses Statment

First Month
Revenues 10,000,000
Cost of Sales 7,500,000
Gross Profit 2,500,000
Expenses 0
Operating Profit 2,500,000
Interest payment 500,000
Net Profit 2,000,000
Comments (optional)
Equity Initial = 150,000,000. 1st month = 152,000,000
Assumption that inventory must prevail on $40,000,000

II. In US dollars, estimate the market size for electric vehicles in Mexico by 2030.
Elaborate on your answer.

The global electric car sales has been increasing in a probable exponential way (few years as sample) since 2010.
The simplest function I could find that most relates to this growth would be.
f(x)= x exp(0.3850*p). p= year. x= cars
According to statista there where 305 electric cars sold in 2019 in mexico, and 2030 - 2019=11
So 305 exp(0.3850*11) = 21,082 cars I Average cost electric car = $55,600 assuming no change in 11 years due technolgy/
innovation price decrement and inflation cancel each other (What increases by inflation, decreases by price of old tech)
USD Market size = $1,172,201,795 USD
Of course the estimation is sensitive to goverment policies and transcendece of electric energy trend.
III. You’ve been commissioned to appraise a property.
The property is one of four identical houses located in downtown Huston.
After interviewing the residents of the other 3 properties you have the following information:
1) The resident of the first house says she built the house 5 years ago and invested a total of US$1 million.
2) The resident of the second house says he pays a US$5,500 monthly rent.
3) The resident of the third house says she acquired the house two years ago for US$1.1 million.
Considering this information, what would be the fair value you estimate for the property?
CAP rate
Description. CAP Rate Huston Rent

New luxury. 4.6 Monthly 5,500
Class A. 4.87 Annual. 66,000. CAP rate Value: $1,273,516.64
Class B 5.24
Class C 6.02
Average 5.1825%
House Growth rate 3.228% Growth rate Value $$1,172,162.43

t-5. 1,000,000.00
t-2. 1,100,000.00
t. 1,172,162.43 Answer, somewhere between this margin
IV. You received US$1 million to secure your retirement; how would you allocate this capital?
I have 40 years left to allocate the capital
Decade Risk free assets. Risky and speculative investments

1 25% 75%
2 41% 59%
3 57% 43%
4 75% 25%
V.Based on the following information, which sector of the FMSE do you think it’s more likely that the company “NTTRO” belongs to? Rank
you answer from 1 to 4 from most likely to least likely and justify your answer.
Within the FMSE there are 100 listed companies, segmented in 4 different sectors:
• 50 in Construction.
• 10 in Technology
• 25 in Food and Beverage
• 15 in Financials
Amin Toufanie
@FMSEBl0gK1nG
The young management team @NTTRO once again delivers to shareholders through innovation and creativity! Buy NTTRO before
it’s to late! #Investing #NTTRO #IVF #FMSE
Sheet Data:
1. Construction
2. F&B
3. Financials
4. Technology
Gathered data from web ————>. IVF= invitro fecundation Amin Toufanie = TLabs CEO (Tech)
Noises/signals— Innovation and Creativity, “Buy NTTRO before its to late” , “young management”
1. Technology
2. Financials
3. F&B
4. Construction
VI. It is estimated that Mexico’s GDP fell by roughly 9% in 2020; however, the Mexican Stock Index or IPC, remained virtually flat when
compared to 2019 numbers. How would you explain this?

Because markets and economy are not the same, even though markets could be clearly influenced by world/country’s economy,
they are free and independent from it. Where subjectivity plays a big part to make participants negotiate and value individual
companies at the price they see most beneficial for their porpuses.

Name: E-Mail: Cell Phone Number:: Balance Sheet Initial 1st Month

Uploaded by

Copyright:

Available Formats

Name: E-Mail: Cell Phone Number:: Balance Sheet Initial 1st Month

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Name: E-Mail: Cell Phone Number:: Balance Sheet Initial 1st Month

Uploaded by

Copyright:

Available Formats

Emiliano Mancilla

Current Assets 50,000,000 52,000,000

Cost Bearing Liabilities 0 0

Profit and Losses Statment

Assumption that inventory must prevail on $40,000,000

Elaborate on your answer.

f(x)= x exp(0.3850*p). p= year. x= cars

III. You’ve been commissioned to appraise a property.

The property is one of four identical houses located in downtown Huston.

Elaborate on your answer.

Description. CAP Rate Huston Rent

House Growth rate 3.228% Growth rate Value $$1,172,162.43

Elaborate on your answer.

I have 40 years left to allocate the capital

Decade Risk free assets. Risky and speculative investments

Elaborate on your answer.

Elaborate on your answer.

You might also like