Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Mansur Store's Financial Analysis: Income Statement & KPIs 2018-2019, Assignments of Finance

An income statement and key performance indicators (kpis) for mansur store's financial performance in the years 2018 and 2019. The income statement includes gross sale, sales deductions, net sale, cost of sale, cost of goods sold, transportation, custom, gross profit, operating expenses, and kpis such as target sale, target rent/sale, target employee/sale, target ebitda, stock turnover rate, gmroi, gmrof, gmrol, trading area, average items per cart, average sale per invoice, conversion rate, and opex. Useful for understanding the financial health of mansur store and identifying trends and areas for improvement.

Typology: Assignments

2019/2020

Uploaded on 05/15/2020

fatihkorkmaz
fatihkorkmaz 🇹🇷

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
State Bağdat
Store Mansur
KPİ Point 8
INCOME STATEMENT 2018 2019 % Change
Gross Sale $ 760,000.00 $ 838,451.00 10%
Sales Deductions $ 152.00 $ 152.00 0%
Campain $ 4,200.00 $ 4,200.00 0%
Net Sale $ 755,648.00 $ 834,099.00 10%
Cost Of Sale $ 390,000.00 $ 419,000.00 7%
Cost of Goods Sold $ 325,000.00 $ 354,000.00 9%
Transportation $ 50,000.00 $ 50,000.00 0%
Custom $ 15,000.00 $ 15,000.00 0%
Gross Profit $ 365,648.00 $ 415,099.00 14%
Opex $ 241,000.00 $ 250,000.00 4%
Rent Exp. $ 120,000.00 $ 120,000.00 0%
Employee Exp. $ 50,000.00 $ 60,000.00 20%
Electric $ 30,000.00 $ 30,000.00 0%
Marketing $ 16,000.00 $ 15,000.00 -6%
Lojistic $ 10,000.00 $ 10,000.00 0%
Headquarter Exp. $ 10,000.00 $ 10,000.00 0%
Others $ 5,000.00 $ 5,000.00 0%
Operation Profit $ 124,648.00 $ 165,099.00 32%
KPİ Curent Targer Point
Target Sale $ 834,099.00 $ 750,000.00 1
Target Rent/Sale 14% 7% 0
Target Employee/Sale 7% 13% 1
Target Ebidta 20% 10% 0
Stock Turnover Rate 5 4.2 1
GMROI 3.2 3 1
GMROF $ 42.00 $ 40.00 1
GMROL $ 11,000.00 $ 10,000.00 1
Average Sale Per Invoice $ 26.00 $ 25.00 1
Average Items per Cart 3.1 3 1
Conversion Rate 13% 15% 0
Opex Operational Expenditure
EBITDA Earnings Before Interests, Taxes, Depreciation and Amortization
Employee Exp. İncudes all cost for employees; salary, food, tax, insurance and transportation
Rent Exp. İncudes all cost for store; rent, tax and monthly payment
Headquarter Exp. (Store Sale / Totaly Sale) * Headquarter Expenses
Stock Turnover Rate Cost Of Sale / Avarege İnventory for Yearly
GMROI Gross Margin Return on İnvesment; Gross Profit / Average İnventory Cost
GMROF Gross Margin Return On Floor space; Gross Profit / Trading Area
GMROL
Gross Margin Return On Labour; Gross Profit / Number of peole employed at the store
Trading Area Trading Area is to be considered, not total area
Average Items per Cart Sum of Products Purchased / Number of Completed Shopping Carts
Average Sale Per Invoice
Total sales for the period (i.e. yearly) / Total number of invoices for the same period (i.e. yearly)
Conversion Rate Total Number of Sales / Number of Unique Visitors
pf2

Partial preview of the text

Download Mansur Store's Financial Analysis: Income Statement & KPIs 2018-2019 and more Assignments Finance in PDF only on Docsity!

State Bağdat Store Mansur KPİ Point 8 INCOME STATEMENT 2018 2019 % Change Gross Sale $ 760,000.00 $ 838,451.00 10% Sales Deductions $ 152.00 $ 152.00 0% Campain $ 4,200.00 $ 4,200.00 0%

Net Sale $ 755,648.00 $ 834,099.00 10%

Cost Of Sale $ 390,000.00 $ 419,000.00 7%

Cost of Goods Sold $ 325,000.00 $ 354,000.00 9% Transportation $ 50,000.00 $ 50,000.00 0% Custom $ 15,000.00 $ 15,000.00 0%

Gross Profit $ 365,648.00 $ 415,099.00 14%

Opex $ 241,000.00 $ 250,000.00 4%

Rent Exp. $ 120,000.00 $ 120,000.00 0% Employee Exp. $ 50,000.00 $ 60,000.00 20% Electric $ 30,000.00 $ 30,000.00 0% Marketing $ 16,000.00 $ 15,000.00 -6% Lojistic $ 10,000.00 $ 10,000.00 0% Headquarter Exp. $ 10,000.00 $ 10,000.00 0% Others $ 5,000.00 $ 5,000.00 0%

Operation Profit $ 124,648.00 $ 165,099.00 32%

KPİ Curent Targer Point Target Sale $ 834,099.00 $ 750,000.00 1 Target Rent/Sale 14% 7% 0 Target Employee/Sale 7% 13% 1 Target Ebidta 20% 10% 0 Stock Turnover Rate 5 4.2 1 GMROI 3.2 3 1 GMROF $ 42.00 $ 40.00 1 GMROL $ 11,000.00 $ 10,000.00 1 Average Sale Per Invoice $ 26.00 $ 25.00 1 Average Items per Cart 3.1 3 1 Conversion Rate 13% 15% 0 Opex Operational Expenditure EBITDA Earnings Before Interests, Taxes, Depreciation and Amortization Employee Exp. İncudes all cost for employees; salary, food, tax, insurance and transportation Rent Exp. İncudes all cost for store; rent, tax and monthly payment Headquarter Exp. (Store Sale / Totaly Sale) * Headquarter Expenses Stock Turnover Rate Cost Of Sale / Avarege İnventory for Yearly GMROI Gross Margin Return on İnvesment; Gross Profit / Average İnventory Cost GMROF Gross Margin Return On Floor space; Gross Profit / Trading Area GMROL Gross Margin Return On Labour; Gross Profit / Number of peole employed at the store Trading Area Trading Area is to be considered, not total area Average Items per Cart Sum of Products Purchased / Number of Completed Shopping Carts Average Sale Per Invoice Total sales for the period (i.e. yearly) / Total number of invoices for the same period (i.e. yearly) Conversion Rate Total Number of Sales / Number of Unique Visitors

mployed at the store he same period (i.e. yearly)