Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fill in the below table to answer your question: 8. Calculate cost of goods sold and estimated annual sales for years 2021-2025, create a
Please fill in the below table to answer your question:
8. Calculate cost of goods sold and estimated annual sales for years 2021-2025, create a depreciation schedule, and complete the following pro forma income statements for Kevin's Convenience Store, LLC considering the following assumptions: Kevin's Convenience Store, LLC List of Assumptions for 2021-2025 48% 2024 2021 2022 2023 2024 2025 Target margin for food inventory: 45% 46% 47% 49% Target margin for non-food inventory: 35% 36% 37% 38% 39% Cost of goods sold for December 2020 is expected to equal $5,000 for food inventory and $3,750 for non-food inventory. Cost of goods sold for 2021 is expected to equal December 2020 cost of goods sold times 12, plus 10%. After 2021, cost of goods sold is expected to increase annually as follows: 2022 2023 2025 7.5% 5% 2.5% 0% During the start-up phase of the business in 2020, $24.000 of depreciable fixed assets with a salvage value of $0 are expected to be purchased. An additional $10,000 of depreciable fixed assets with a salvage value of $1,000 are expected to be purchased in 2023. No fixed assets are expected to be disposed of until after 2025. All fixed assets are expected to have a useful life of five years and will be depreciated using the straight-line, half-year convention depreciation method. Information regarding expected expenses: In 2022. payroll is expected to increase 5% from its year 2021 level of $22.880 and then stabilize. Payroll taxes are expected to be 13% of payroll. Insurance expense is expected to be $300 per month in 2021 and increase 3% every year after 2021. Miscellaneous expense is expected to amount to $1,225 for 2021. Miscellaneous expense is expected to amount to 2% of the prior period's cost of goods sold for years 2022-2025. Rent is expected to be $2,000 per month until it increases 5% in July 2023. Utilities are expected to be $400 per month in 2021 and increase 2% every year thereafter. Cleaning and maintenance expense is expected to be $500 per month in 2021 and 2022 and increase 5% in 2023. Kevin's Convenience Store, LLC Pro Forma Income Statements For the Years Ended December 31, 2021, 2022 2023 2024 and 2025 2021 2022 2023 2024 Sales Cost of goods sold Gross profit 2025 Operating expenses Rent Payroll Payroll taxes Utilities Insurance Depreciation Cleaning and maintenance Miscellaneous Total operating expenses Net incomeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started