Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / 1) Which of the following is NOT a best practice for financial model inputs? Protect inputs by locking input cells Use colour to separate inputs from outputs Add comments to cells to give more information Data should only be entered once   2

1) Which of the following is NOT a best practice for financial model inputs? Protect inputs by locking input cells Use colour to separate inputs from outputs Add comments to cells to give more information Data should only be entered once   2

Finance

1) Which of the following is NOT a best practice for financial model inputs?

Protect inputs by locking input cells

Use colour to separate inputs from outputs

Add comments to cells to give more information

Data should only be entered once

 

2. Complex financial models are all of the following EXCEPT:

Review Later

They are more prone to error due to size and complexity

They typically model most outputs from first principles

They offer users a high degree of precision

They are easy to follow and audit

 

3. Forecast the 2019 Cost of goods sold on the previous year’s number and the assumptions

 

2018 Actual

2019 Estimate

Sales Growth

6%

8%

Gross Margin

40%

40%

Revenues

50,000

 

Cost of Goods Sold

27,000

 

 

Review Later

35,200

32,400

29,160

26,630

 

4. Forecast the accounts receivable for Company XYZ using the following annual information.

  • Receivable days assumption = 55 days
  • Payable days assumption = 69 days
  • Forecasted revenue = $263,500
  • Forecasted cost of goods sold = $114,780

Review Later

21,698

17,296

39,705

49,812

 

5

5. What formula below can be used to forecast inventory?

Review Later

(Inventory days / Cost of sales) x 365

(Inventory days / 365) / Cost of sales

(Inventory days / 365) x Cost of sales

(Inventory / Cost of sales) x 365

 

 

6. Which of the following items can be found in a published cash flow statement under "operating activities"? Select ALL correct answers.

Review Later

Capital expenditures

Dividends paid

Depreciation

Issuance of common stock

Changes in operating assets and liabilities

 

 

7. What is the total cash from operating activities based on the information below?

  • Net income: 500
  • Depreciation: 80
  • Increase in receivables: 100
  • Increase in inventory: 50
  • Increase in payables: 60
  • 370
  • 540
  • 490
  • 630

 

8. Calculate the end of the year cash balance based on the information below:

  • Beginning of the year cash balance: 2,000
  • Net income: 300
  • Depreciation: 140
  • Positive changes in operating assets and liabilities: 60
  • Acquisitions of PP&E: 580
  • Dividends paid in the current year: 130
  • Increase in long-term debt: 200

Review Later

2,470

1,990

1,310

1,710

 

9. Which Excel function or tool will you use to display the cells that are referred to by a formula in the selected cell?

Review Later

Trace Dependents

Show Formulas

Trace Precedents

Go To Special – Formula

 

10. What is the forecasted value of property, plan and equipment (PP&E) based on the following information:

  • Capital asset turnover ratio: 2.5
  • Forecasted revenues: $120
  • Forecasted costs of goods sold: $80

Review Later

48

52

40

32

11. What is the impact on cash flow from operations in the current year based on the net change in operating assets and liabilities listed below?

 

 

 

Review Later

200

-200

-150

0

 

12. What’s the forecasted capital expenditure based on the information below?

  • Net PP&E beginning of period: 15,000
  • Net PP&E end of period: 17,500
  • Depreciation expenses: 2,400

Review Later

-100

100

2,500

4,900

 

13. What’s the retained earnings end of period based on the information below?

  • Retained earnings beginning of period: 7,500
  • Net income: 2,300
  • Dividends paid: 1,700

Review Later

11,500

6,900

8,100

7,400

14. What’s the depreciation expense based on the information below?

  • Depreciation (percent of sales): 4%
  • Revenues: 60,000
  • Gross profit: 25,000
  • PP&E: 40,000

Review Later

1,000

2,600

2,400

1,600

 

15. What’s the forecasted EBIT based on the information below?

  • Revenues: 56,000
  • Cost of goods sold: 32,000
  • SG&A: 8,500
  • Depreciation: 2,700
  • Interest: 1,200
  • Taxes: 3,800

Review Later

7,800

15,500

12,800

11,600

Option 1

Low Cost Option
Download this past answer in few clicks

3.87 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 7 times

Completion Status 100%

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.8)

Google (5.0)