Lab Excel Chapter 4 Grader Project And Unit 15 Skills Test

/in /by

Office 2016 – myitlab:grader – Instructions Excel Project

EX16_XL_CH04_GRADER_ML1_HW – Pet Supplies 1.5

 

Project Description: You are the inventory manager for Crafton’s Pet Supplies. You are currently preforming analysis to determine inventory levels, as well as the total value of inventory on hand. Your last steps will be to check the report for duplicate entries and format for printing.

 

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Open the download file exploring_e04_grader_h2_start.xlsx. 0.000 2 Freeze the panes so that the column labels do not scroll off screen. 5.000 3 Convert the data to a table and name the table Inventory2018. 10.000 4 Apply Table Style Medium 3 to the table. Note, depending on the version of Office used, the table style name may be Orange, Table Style Medium 3. 5.000 5 Sort the table by Warehouse (A to Z), then by Unit Price (smallest to largest), and then by Department. Create a custom sort order for Department so that it appears in this sequence: Food & Health, Collars & Leashes, Toys, Clothes, Training, and Grooming. Note, Mac users to create a custom order list on the Excel menu, click Preferences, and then under Formulas and Lists, click Custom Lists. Click Add. 10.000 6 Remove duplicate records from the table. Excel should find and remove one duplicate record. 5.000 7 Create an unqualified structured reference in column G to determine the value of the inventory on hand and apply Accounting Number Format. To calculate the inventory on hand multiply the Unit Price and the Amount on Hand. 10.000 8 Apply a Total Row to the Inventory2018 table, set the Inventory Value to Sum, and the Amount on Hand to Average. Format the results to display with two decimal points. 15.000 9 Create a new conditional formatting rule that displays any Inventory Value for the Food & Health department with a value of $30,000 or more as Red fill color (second column, last row). There will be two qualifying entries. Note, Mac users select the range G2:G78. Then in the New Formatting Rule dialog box, select the style Classic. 15.000 10 Ensure the warehouse information is not broken up between pages when printed. Add a page break to make sure that each warehouse prints on its own consecutive page. 10.000 11 Set the worksheet to Landscape orientation, and repeat row 1 labels on all pages. 10.000 12 Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the sheet. 5.000 13 Display the Inventory sheet in Page Break Preview. 0.000 14 Save and close the workbook. 0.000 Total Points 100.000

 

 

Updated: 08/28/2017 1 Current_Instruction.docx

The cost of debt is generally lower than the cost of equity.

/in /by

The cost of debt is generally lower than the cost of equity.

Top of Form

 

True

 

False

Bottom of Form

 

 

M&M’s Proposition I states that a company’s value is independent of its capital structure.

Top of Form

 

True

 

False

Bottom of Form

 

 

A higher level of leverage generally reduces managerial discretion.

Top of Form

 

True

 

False

Bottom of Form

 

 

 

The Pecking Order Theory of capital structure implies a unique optimum capital structure.

Top of Form

 

True

 

False

Bottom of Form

 

 

 

As EBIT drops, the return on equity (ROE) of a levered firm drops ______ the ROE of an otherwise identical unlevered firm.

Top of Form

 

the same as

 

relatively more than

 

relatively less than

 

more or less than (it cannot be determined)

Bottom of Form

 

 

 

 

Shareholders prefer high risk projects when facing a high probability of bankruptcy because

Top of Form

 

High risk projects usually bring high rewards.

 

Shareholders have the residual claim on a company.

 

Creditors have the residual claim on a company, and therefore bear the risk.

 

There is a good chance the government will rescue them in bankruptcy.

Bottom of Form

 

 

 

The _________ states that the value of the firm is determined solely by the value of its assets.

Top of Form

 

Static Tradeoff Model

 

M&M proposition I

 

The Pecking Order Model

 

Agency Theory

Bottom of Form

 

 

Which of the following expresses the value of a levered firm (VL) in the Static Tradeoff model of optimal capital structure? [Note: VU denotes the value of the unlevered firm; CFD denotes expected costs of financial distress; and PV denotes present value.]

Top of Form

 

VL = PV(Tax Shield) – PV(CFD)

 

VL = VU + PV(Tax Shield) / PV(CFD)

 

VL = VU + PV(Tax Shield) – PV(CFD)

 

VL = VU + PV(Tax Shield)

Bottom of Form

 

 

 

A example of indirect costs of bankruptcy is

Top of Form

 

Court costs

 

Attorney and advisor fees

 

Lost sales due to costumers and suppliers lost trust

 

All of the above

Bottom of Form

 

 

Which of the following are equivalent under M&M proposition I?

Top of Form

 

Maximizing firm value and maximizing firm profit

 

Maximizing firm value and minimizing the cost of capital

 

Minimizing firm’s cost of capital and minimizing firm’s debt burden

 

Maximizing profit and minimizing taxes

Bottom of Form

 

 

 

 

Positioning Statement And Motto

/in /by

Positioning Statement and Motto

In this assignment, you will create a Positioning Statement and Motto for Amazon.com. Use the information listed, as well as your own research, to assess the brand by completing the provided template. At the end of the template, be sure to develop what you believe would be a new or better positioning statement and motto for the brand.

StrayerLogoHoriz_RGB Assignment 1 Positioning Statement and Motto

 

Use the provided information, as well as your own research, to assess one (1) of the stated brands (Jeep Cherokee, Amazon, or Google) by completing the questions below. At the end of the worksheet, be sure to develop a new positioning statement and motto for the brand you selected. Submit the completed template in the Week 4 assignment submission link.

 

Name:

Professor’s Name:

Course Title:

Date:

Company/Brand Selected (Jeep Cherokee, Amazon, or Google):

 

 

1. Target Customers/Users

Who are the target customers for the company/brand?

[Insert response]

 

How could/does the company reach its customers/users? What methods and media might and/or does the company use to reach the customers/users?

[Insert response]

 

What would grab the customers/users’ attention? Define the customers/users according to their demographics and psychographic information (e.g., age, gender, income, education, lifestyle, values, etc). How do they want to be perceived?

[Insert response]

 

What do these target customers’ value?

[Insert response]

 

2. Competitors

Who are the brand’s competitors?

[Insert response]

 

What product category does the brand fit into?

[Insert response]

 

What frame of reference will customers use in making a choice to use/purchase this brand/service? What other brands/companies might customers compare this brand to?

[Insert response]

 

3. USP (Unique Selling Proposition)

How is this brand/company better than its competitors? What is the brand’s USP (Unique Selling Proposition?

[Insert response]

 

What is the brand’s uniqueness?

[Insert response]

 

What is the competitive advantage of the brand? How is it different from other competing brands?

[Insert response]

 

Does the brand have any attributes or benefits that dominate competitors?

[Insert response]

 

4. Positioning Statement & Motto

Develop a new positioning statement and motto for the brand you selected. Below is an example of BMW’s positioning statement and motto.

· BMW Positioning statement: The brand for discerning customers of sports cars (target customers) who want an exhilarating experience (USP).

· BMW Motto: BMW is the ultimate driving machine.

[Insert response]

 

© 2015 Strayer University. All Rights Reserved. This document contains Strayer University confidential and proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.

MKT 100 Assignment 2 1156 (5-15-2015) Page 2 of 2

Finance Multiple Choice Questions

/in /by

All else constant, what would Baldwin’s SG&A/Sales ratio be if the company had spent an additional $1,500,000 for Buddy’s promotional budget and $750,000 for Buddy’s sales budget?
Select: 1
11.3%
8.4%
11.8%
9.8%
The Chester’s balance sheet has $106,417,000 in equity. Further, the company is expecting $3,000,000 in net income next year. Assuming no dividends are paid and no stock is issued, what would their Book Value be next year?
Select: 1
$16.22
$71.60
$32.41
$33.33
Chester Corp. is downsizing the size of their workforce by 10% (to the nearest person) next year from various strategic initiatives. How much will the company pay in separation costs if each worker receives $5,000 when separated?
Select: 1
$225,000
$2,030,000
$90,000
$812,000
In the Month of March, Baldwin Corporation received orders of 162 units at a price of $15.00 for their product Bold. Baldwin uses the accrual method of accounting and offers 30 day credit terms. Baldwin delivers 108 units in March and the balance of 54 units in April. They received payment for 54 units in March, 54 units in April, and 54 units in May. How much revenue is recognized on the March income statement from this order? How much in the April Income statement? (Answer in thousands)
Select: 1
$2,430 , 0
0 , $2,430
$1,620 , $810
$810 , $810
Your Competitive Intelligence team is predicting that the Baldwin Company will invest in adding capacity to their Baker product this year. Assume Baldwin’s product Baker invests in increasing its capacity by 10% this year. Because of this new information, your company anticipates all other products in the Core segment will increase their capacity by the same amount. How much can the industry produce in the Core segment the next year? Consider only products primarily in the Core segment last year. Ignore current inventories. Figures in thousands (000).
Select: 1
8,725
9,702
7,675
8,652
11,066
3,980
7,668
Assume Andrews is paying a dividend of $1.38 (per share). If this dividend was raised by 15%, given its current stock price, what would be the Dividend Yield?
Select: 1
0.9%
134.5%
0.7%
0.7%
Last year Abby charged $2,753,867 Depreciation on the Income Statement of Andrews. If Abby sold a fully depreciated piece of equipment at a loss, the effect on Andrews’s financial statements would be (all other items remaining equal):
Select: 1
Decrease Net Cash from operations on the Cash Flow Statement
No impact on Net Cash from operations
Increase Net Cash from operations
Just impact the Balance Sheet
The Baldwin company wants to decrease its plant utilization for Buddy by 15%. How many units would need to be produced next year to meet this production goal? Ignore impact of accounts payable on plant utilization.
Select: 1
1,305
1,782
2,030
1,535