# week 3 excel sheet Excel for Corporate Finance Professionals” by Michael McDonald from LinkedIn Learning from Wk 1. Sections “NPV Tests in Excel” and “NPV

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Excel for Corporate Finance Professionals” by Michael McDonald from LinkedIn Learning from Wk 1. Sections “NPV Tests in Excel” and “NPV and Scenario Analysis” may be helpful for understanding this exercise.

##### Assignment Directions

Individually, complete all sets and parts of the Financial Exercises individually to prepare for your Wk 3 – Group: Financial Exercises Summary assignment. The file contains the following 5 worksheet tabs to complete:

• Wk 3: Set 1, Part 1
• Wk 3: Set 1, Part 2
• Wk 3: Set 2, Part 1
• Wk 3: Set 2, Part 2
• Wk 3: Set 2, Part 3

## Index

 Workbook Index Wk 3 – Set 1, Part 1 Wk 3 – Set 1, Part 2 Wk 3 – Set 2, Part 1 Wk 3 – Set 2, Part 2 Wk 3 – Set 2, Part 3

## Wk 3 – Set 1, Part 1

&”Arial,Regular”&10 Wk 2 Financial Exercises – Part 1
HCS/385 v4
Page &P of &N

&”Arial,Regular”&10HCS/385 v4

## Wk 3 – Set 1, Part 2

&”Arial,Regular”&10Wk 2 Financial Exercises – Part 2
HCS/385 v4
Page &P of &N

&”Arial,Regular”&10HCS/385 v4

## Wk 3 – Set 2, Part 1

 Describe the 5 types of budgets listed for these Wk 3 Financial Exercises: Problem Set 2, Part 1. In your descriptions, include the budget’s objective, how the budget assists an organization in managing its financial activities, and what types of data need to be included in that specific budget. Type of Budget Description Cash Flow Insert cash flow description. Operating Insert operating description. Sales Insert sales description. Static Insert static description. Financial Insert financial description.

## Wk 3 – Set 2, Part 2

 Complete the following 3 Wk 3 Financial Exercises: Problem Set 2, Part 2 problems using the following ratios: Sales level at which operating income is zero o    If sales above breakeven, then profit o    If sales below breakeven, then loss o    Fixed expenses = total contribution margin Total sales = total expenses Break Even Point: Unit Sold = Fixed expenses + Operating Income / Contribution Margin per unit Break Even Point: Sales \$ = Fixed expenses + Operating Income / Contribution Margin Ratio Problem Answer 1. Calculate the break even number of units if the fixed expenses are \$7,000 and the contribution margin is \$14 per unit. Insert your answer. 2. Calculate the break even sales dollars if the fixed expenses are \$7,000 and the contribution ratio is 40%. Insert your answer. 3. Calculate the break even number of units with a target profit of \$120,000 if the fixed expenses are \$15,000 and the contribution margin is \$60 per unit. Insert your answer.

## Wk 3 – Set 2, Part 3

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

#### Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Latest Questions

See More »

See More »

See More »

See More »

See More »

See More »