Write a mission statement, strategy, and objective for the following company $(3$ points$).($Module $1$ Unit $2)$

Company: WareHouse

A furniture company aiming to provide basic furniture essentials to low income members of society. They use recycled or unused materials from higher end furniture companies which helps keep costs low and makes each product slightly different from another.

Discuss how the proposed project aligns with your strategy and$/$or objective $(2$ points$).($Module $1$ Unit $2)$

Project:

Designing and launching a website where other furniture stores can arrange to sell them their unused or extra materials. Questio $2$ is Consider the project given to you above in question $1$ of this assignment. Create a work breakdown structure outlining $3$ main cost sources and their corresponding activities. Present it in a hierarchy such as the one in the slides for Module $5$ Unit $1.(5$ points$).$ Explain why each cost is direct or indirect, fixed or variable, and why they belong in the project budget rather than the company budget $(10$ points$).($Module $3$ Unit $1).$ Question $3$ is Consider the project given to you above in question $1$ of this assignment. Explain one risk this type of project might have $(2$ points$).$ Suggest and explain one mitigation solution for this type of risk $(3$ points$).($Module $5$ unit $2).$ Question $4$ is Question $4$

$15$

Points

Ratio

Company

Industry averages

Profitability Ratios

Return on Equity

$3\mathrm{.}9\%$

$13\mathrm{.}0\%$

Return on Captial

$2\mathrm{.}6\%$

$10\mathrm{.}1\%$

Net Profit Margin

$3\mathrm{.}9\%$

$11\mathrm{.}0\%$

Operating Profit Margin

$5\mathrm{.}8\%$

$15\mathrm{.}2\%$

Gross Profit Margin

$41\mathrm{.}8\%$

$38\mathrm{.}20\%$

Activity Ratios

Total Asset Turnover Ratio

$0\mathrm{.}69$

$2\mathrm{.}2$

Fixed Asset Turnover Ratio

$0\mathrm{.}85$

$8\mathrm{.}5$

Working Capital Ratio

$23\mathrm{.}34$

$20$

Inventory Turnover Ratio

$3\mathrm{.}42$

$6\mathrm{.}43$

Days of Inventory on Hand

$106\mathrm{.}73$

$67\mathrm{.}31$

Accounts Receivable Collection $($days$)$

$26\mathrm{.}06$

$20\mathrm{.}03$

Accounts Payable Collection $($days$)$

$49\mathrm{.}28$

$40\mathrm{.}5$

Solvency Ratios

Leverage

$1\mathrm{.}47$

$3\mathrm{.}2$

Debt to Equity

$0\mathrm{.}47$

$1\mathrm{.}1$

Times Interest Earned Ratio

$1\mathrm{.}96$

$7\mathrm{.}8$

Current Ratio

$1\mathrm{.}18$

$3\mathrm{.}82$

Quick Ratio

$0\mathrm{.}46$

$1\mathrm{.}7$

Using the above table discuss one area the company is performing well in $(3$ points$)$ and three areas they are performing poorly in $(9$ points$)$ based on their financial ratios. $($Module $2).$ What type of funding, debt OR equity $($NOT BOTH$)$ should this company consider for its projects? $(3$ points$)($Module $3$ Unit $2).$

Question $5$

$10$

Points

Project A

Year $0-1$

Year $1-2$

Year $2-3$

Beginning cash

Cash Receipts

Client Payments

$$10,000$

$$40,000$

$$85,000$

Investor Proceeds

Other

$$10,000$

Total

$$20,000$

$$40,000$

$$85,000$

Cash Payments

Materials

$$50,000$

Down and monthly payments for equipment

$$10,500$

$$1,500$

$$1,500$

Labor Salary

$$15,000$

$$6,000$

$$6,000$

other

$$4,000$

$$1,000$

$$11,000$

Total

$$79,500$

$$8,500$

$$17,500$

Net

$$(59,500)$

$$30,500$

$$66,500$

For the following questions please SHOW YOUR WORK TO RECEIVE CREDIT. You can attach a file to your submission. Excel files using the NPV formula WILL NOT RECEIVE CREDIT.

Given a WACC of $8\mathrm{.}7\%,$ the NPV of this project is Blank $1(4$ points$).($Module $4$ Unit $1$&$2).$ The discounted payback period is Blank $2(2$ points$).($Module $4$ Unit $2)$

For the following questions enter either accept or reject into the blank.

Given another project $($Project B$)$ that was independent of the above project $($Project A$)$ with a NPV of $$11,570,$ what would recommend?

Blank $3$ Project A$.(1$ point$).$

Blank $4$ Project B$.(1$ point$).$

Given another project $($Project B$)$ that was mutually exclusive with the above project $($Project A$)$ with a NPV of $$11,570,$ what would recommend?

Blank $5$ Project A$.(1$ point$).$

Blank $6$ Project B$.(1$ point$).$

Blank $1$

Add your answer

Blank $2$

Add your answer

Blank $3$

Add your answer

Blank $4$

Add your answer

Blank $5$

Add your answer

Blank $6$

Add your answer