Create an Excel Spreadsheet based on the example we discussed in class for Lemonade Inc. to answer
Question:
Create an Excel Spreadsheet based on the example we discussed in class for Lemonade Inc. to
answer the following questions using the following data:
Lemonade Inc. Balance Sheet Exercise
● Lemons and Sugar and Cups: $1,800
● Cash: $300
● Biff owes us $1,000 for his monthly tab
● The Stand and Equipment and License from the University: $2,000
● Vendor Bills: $1,600
● Loan from the bank of $1,000
Lemonade Inc. Income Statement Exercise
● Sales 2018: $12,000
● Cost of the cups and lemons and sugar and stuff to make each cup: $8,300
● General & Administrative Expenses: $1,700
● Interest on $1,000 loan at 10% per year: $100
● Tax rate: 35%
1. What does the Balance Sheet of Lemonade Inc. look like on 12/31/2018?
2. What does the Income Statement of Lemonade Inc. look like for the year ending
12/31/2018?
B- 1) What does Revenue reflect on Walmart’s Condensed Consolidated Statements of Income? (Hint: What does it mean and how is it calculated?)
2. How much has Walmart’s Revenue changed from Fiscal Year 2021 to Fiscal Year 2022? (Please show your answer in percentage)
3. What does Cost and Expenses reflect on Walmart’s Condensed Consolidated Statements of Income? (Hint: What does it mean and how is it calculated?)
4. How much has Walmart’s Cost and Expenses changed from Fiscal Year 2021 to Fiscal Year 2022? (Please show your answer in percentage)
5. What does Total Equity reflect on Walmart’s Condensed Consolidated Balance Sheet? (Hint: What does it mean and how is it calculated?
6. How much has Walmart’s Total Equity changed from Fiscal Year 2021 to Fiscal Year 2022? (Please show your answer in percentage)
Fundamentals of Investing
ISBN: 978-0133075359
12th edition
Authors: Scott B. Smart, Lawrence J. Gitman, Michael D. Joehnk