Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. In the model below, Amy used sensitivity analysis in a cashflow projection to check how her assumptions affect her need to finance operations through

image text in transcribed

9. In the model below, Amy used sensitivity analysis in a cashflow projection to check how her assumptions affect her need to finance operations through credit or loans during the coming year. This question has two parts. First, think about which one outcome variable is most clearly related to the need to plan for financing operations. Then identify which assumption she should make sure she has estimated correctly, since the outcome variable is most sensitive to changes in that assumption. The range B4:F6 show current best assumptions. Range B8:F18 show 10% changes in the three assumptions. Provide as your answer the assumption variable you've identified. D E F 1 SMALL BUSINESS CASH FLOW PROJECTION 2 Innovative Speakers Cashflow minimum $ 267 Margin 21% End period cash balance $12,469 Return rate 10% Unit price $ 89 Advertising budget $ 2,000 Cashflow minimum $ 187 Margin 20% End period cash balance $11,845 Return rate 11% Unit price $ 89 Advertising budget $ 2,000 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Cashflow minimum $ 227 Margin 18% End period cash balance $10,598 Return rate 10% Unit price $ 98 Advertising budget $ 2,000 293 Cashflow minimum $ Margin 23% End period cash balance $ 13,716 Return rate 10% $ 89 Advertising budget $ 2,200 Unit price Margin Unit price Advertising budget Return rate All of these are true

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Michael Saylor On Bitcoin The Very First Interviews

Authors: Coinan The Barbarian ,Satoshi Nakamoto

1st Edition

979-8423442019

More Books

Students also viewed these Finance questions