Question
Arabelle is considering expanding the floor area of her high-fashion import clothing store, The French Prints of Arabclle, by increasing her leased space in the
Arabelle is considering expanding the floor area of her high-fashion import clothing store, The French Prints of Arabclle, by increasing her leased space in the upscale Cherry Creek Mall from 2,000 square feet to 3,000 square feet. The Cherry Creek Mall boasts one of the countrys highest ratios of sales value per square foot. Rents (including utilities, security, and similar costs) are $110 per square foot per year. Salary increases related to French Prints expansion are shown in the following table, along with projections of sales per square foot. The purchase cost of goods sold averages 70 percent of the sales price. Sales are seasonal, with an important peak during the year-end holiday season.
Year | Quarter | Sales (Per squar ft) | Incremental Salaries |
1 | 1 | $90 | $12,000 |
2 | 60 | 8,000 | |
3 | 110 | 12,000 | |
4 | 240 | 24,000 | |
2 | 1 | 99 | 12,000 |
2 | 66 | 8,000 | |
3 | 121 | 12,000 | |
4 | 264 | 24,000 |
a. If Arabelle expands French Prints at the end of year 0, what will her quarterly pretax cash flows be through year 2?
b. Project the quarterly pretax cash flows assuming that the sales pattern (10 percent annually compounded increase) continues through year 3.
(Please show with excel steps)
Step 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