70.2K

Verified Solution

Link Copied!

You're managing app campaigns for a financial services company. Which of the following assets should you use?

A screen$-$capture video of someone exploring their financial performance page

An image of someone holding a phone with the app on$-$screen and a logo overlayed

A video that tells a complete story, including the user's financial problem and how the app solves it

A headline that states the name of the app and a call$-$to$-$action to download

Walmart's net sales in fiscal year $2024$ increased $$6\mathrm{.}1\%$ from $2023$ to $$642,637$ million, its gross

profit $($or margin$)$ increased $20$ bps to $23\mathrm{.}7\%,$ and its operating income $($or profit$)$ rate increased $80$

bps to $4\mathrm{.}2\%$ from $2023.$

$2024$

A$.$ Please complete Walmart's P&L statement for FY $2024$ and $2023.$

B$.$ According to its annual report, Walmart paid $$5,578$ million tax in FY $2024($ended in January $31)$

and its total adjusted income before tax is $$21,848$ million. Please calculate Walmart's effective

tax rate and its net profit $ and $\%($of net sale$).$

C$.$ How does Walmart's sales $ and net profit $\%$ compare with others we have learned so far.

A local boutique store has the following financial data from last year available: sales or revenue at

$$750,000,$ operating expenses' percentage at $30\%,$ and operating profit at $15\%.$ For this year, sales

are expected to increase $18\mathrm{.}0\%$ while COGs $ is also expected to increase $15\%$ from last year's COGs

$ figure due to increasing shipping container cost from overseas. The store's operating expenses $($$$)$

is expected to increase $8\mathrm{.}4\%$ from last year's $ figure due to higher labor cost.

A$.$ Layout the store's P&L statements of This Year and Last Year side by side and solve all P&L

elements. Show how with

B$.$ Compare the store's operating profit $ and $\%$ between the two years

C$.$ Apply bps points to describe the store's gross margin$\%$ and operating profit$\%$ change.

The following data are from a local boutique. Please complete the following tasked based on the

data:

A$.$ Find out the total reduction occurred $($$ and $\%)$; total cost of goods $

B$.$ set up and complete an expanded P & L Statement $($ $ and $\%)$ for the boutique. Provide formulas

for each of your calculation on the right side of the table; and

C$.$ Find out the $\frac{\text{I}}{M}U\%$ for first pricing.

rotal reduct $=15+2\mathrm{.}5+2=9\mathrm{.}5$

Net sales $=$$$950,000\mathrm{.}00$

Return and employee discount $=2\mathrm{.}0\%$

markdowns $=15\%$

Invoice $=$$$430,000\mathrm{.}00$

Shortages $=2\mathrm{.}5\%,$

Transportation $=$$$25,000$

Alteration $=$$$30,000\mathrm{.}00$

Cash discount $=$$$30,000$

Operating Expenses $=29\%$

cogs$=$ invice, Atteotion, trionsportation $-$cash disceant

Excel $($this question is online submission$)$:

a$.$ Complete and compare Walmart and Amazon's P&L statements in $2023$ and solve all

elements. Then insert a text box to comment on the top two retailers' performance.

b$.$ Apply sorting to identify top $10$ apparel companies by revenue$ of most recent year.

c$.$ Apply conditioning formatting to identify and mark top $10\%$ apparel companies by revenue

$\%$ change or growth

Answer & Explanation Solved by verified expert

See Answer