Chat with us, powered by LiveChat I need help with these problems. The spread sheet with the info is just for help with the assignment | Office Paper
+1(978)310-4246 credencewriters@gmail.com
  

I need help with these problems. The spread sheet with the info is just for help with the assignment. the other spreadsheet that is blank is for answers. 

BUAD 340 Fall 2021 Final Version B November 18, 2021/Dr. Michael O. Minor

Follow the instructions for each section. Your answers should reflect the content of the class PowerPoint Presentations, Units 1-4 exams, readings and other handouts, webpage references, and your lecture notes. Once completed, submit your answers via e-mail as an MS Word document attachment to

[email protected]

by 3:59 p.m. CT tomorrow (Friday, November 19, 2021). Be sure to include the question number before you type your answers. Using “Googled” information in your responses, although the information might be correct, will result in no credit for that question. Type your name in the header of your completed document so that your name shows on each page.

1. In practice, what are the most popular capital budgeting techniques? Why do you think the top three techniques are so popular?

2. A Bishop Companies perpetual bond provides a 5% coupon payment. Several potential investors have a required rate of return of 17%. What would be the value of a Bishop Companies perpetual bond? (Use an Excel Spreadsheet to calculate your answer.)

3. Kimyata is considering purchasing some bonds from the Bishop Companies. She has a required rate of return of 13%. For Kimyata, how much would a 12% typical paying Bishop Companies 20-year coupon bond be worth? (Use an Excel Spreadsheet to calculate your answer.)

4. If you have a good friend, what type of OTC investment would you recommend? Why?

5. How are preferred stocks bonds? How are they different?

6. In what ways do personal values and culture influence ethics?

7. Which of the Ten Principles of Financial Management is your least favorite? Why?

Scenario 1

Keishuna is a consultant for the owners of a ten-year-old car dealership. The owners currently operate under a partnership agreement. One of the owners is in bad health. In the future, the owners would like to open dealership across the countries. They ask you for advice on plotting the financial future of their dealership. After conducting your analysis, in your executive summary, you provide guidance on the most viable legal structure for the company and suggestions on how to value the dealership. (Note: To answer this question, write a short executive summary discussing the viable legal structure and valuation methods.)

Scenario 2

You are the CFO of a Fortune 100 company. Your firm recently purchased a rival firm for $1.75 billion in a stock and cash offer. You have a portfolio of independent projects. Three is your lucky number. You always include the number three when you play the lottery. For the fiscal year ending May 31, 2022, your company has allotted $100 million to invest in capital projects. They also allotted $100 million for state political lobbying efforts. You think the $100 million for lobbying should have been cut by 75% and the difference added to the capital projects budget. After calculating the net present value of each project in your portfolio, you have the following values:

Project A: $50 million

Project B: $40 million

Project C: $10 million.

Also, Project D had a net present value of $90 million.

How many projects are your company able to invest in? Which project or projects would you recommend? What about Project D?

Scenario 3

Ron really wants Tiffany to invest in his company – Bishop Companies. Ron’s company plans to begin offering annual dividends of $.39 starting next year. Ron reminds Tiffany about taking Dr. Minor’s finance course at LOC. His CFO expects their dividend to grow at 3.17% annually for the foreseeable future. Tiffany’s credit union is offering long term CD rates of 5.9%. Currently, Ron’s company’s stock is trading at $3.75.

Calculate the intrinsic value of the Bishop Companies’ stock. At the stock price you calculated, would the Bishop Companies’ stock be a good stock for Tiffany to purchase? Why or why not? What is the market value if there are 1 million outstanding shares?

Scenario 4

Tiffany decides to invest in the Bishop Companies. However, she doesn’t want to put all her eggs in one basket. So, she has Yosvany split the money in her a long-tern CD with 60% invested in the Bishop Companies and 40% invested in Erisha Industries. Since you may have incorrectly made some calculations previously, assume that the expected return and standard deviation of the Bishop Companies is 16% and 21.30% respectively. The expected return and standard deviation of Erisha Industries is 18% and 26.30% respectively. The correlation coefficient between Delta and Epsilon is 0.71.

What is the expected return of the portfolio? Relatively speaking, assume that the combined portfolio’s coefficient of variation is better than its coefficient of variation when compared to the other two investments. How would you explain this apparent contradiction?

Scenario 5

You are the CFO of the Bishop Companies. You are working on the team considering taking the Bishop Companies public. You have prepared a pro forma financial statement for the next four years including ratio analysis. You assume that the year four after tax cashflow will continue indefinitely. Your projection assumes an initial investment infusion from the IPO of $100 million. You use the five capital budgeting techniques you learned in Dr. Minor’s class to evaluate the viability of the IPO for would be investors.

Your firm has summed the following components to calculate your firm’s required rate of return:

Firm Investment Flexibility Rate: 6%;

Expected Inflation Rate: 4.5%; and

Company Risk Premium: 6.5%.

Using your pre-assigned set of pro forma financial statements and the Exam 4 answer key template, you will complete the following analyses:

1. capital budgeting analysis using the five capital budgeting techniques discussed in Unit 4 and

2. pro forma financial statement analysis using the ratio analysis matrix in your pre-assigned set of financial statements.

After you complete your analysis, answer the following questions:

A. What can you say about the Bishop Companies’ projected profitability?

B. With an “A” being excellent and an “F” being horrible, how would you grade the Bishop Companies’ overall projected efficiency?

C. What can you say about the company’s projected working capital?

D. How attractive would an investment in the Bishop Companies to a would-be investor?

E. Based upon your analysis, would you invest in the Bishop Companies if you had the opportunity?

F. Which method of evaluation do you feel most confident?

G. Why do you feel so confident about this evaluation method?

(Note: To receive full credit for your answer, you must use an Excel spreadsheet(s) for your calculations. Be sure to name each capital budgeting evaluation technique you use before each set of calculations.)

A

Are you using the correct spreadsheet? This is Spreadsheet A.
The Bishop Companies, Incorporated Pro Forma Financial Statements
Income Statement
Period Ending: 9/30/22 9/30/23 9/30/24 9/30/25 RATIO ANALYSIS MATRIX
Net Sales $246,486,000 $275,059,000 $242,571,000 $179,186,000
Cost of Goods Sold $188,312,000 $249,259,000 $203,752,000 $158,267,000 BALANCE SHEET RATIOS: Stability (Staying Power)
Gross Profit $58,174,000 $25,800,000 $38,819,000 $20,919,000 1 Current
Current Assets ERROR:#DIV/0!
Operating Expenses: Current Liabilities
Sales, General and Admin. $13,706,000 $14,950,000 $14,532,000 $13,276,000 2 Quick
Non-Recurring Items $2,515,000 ($1,510,000) $17,000 $0 Cash + Accts. Rec. ERROR:#DIV/0!
Other Operating Items $8,771,000 $0 ($1,714,000) $0 Current Liabilities
EBIT $33,182,000 $12,360,000 $25,984,000 $7,643,000 3 Debt-to-Worth
Interest Expense $559,000 $642,000 $851,000 $1,279,000 Total Liabilities ERROR:#DIV/0!
EBT $32,623,000 $11,718,000 $25,133,000 $6,364,000 Net Worth
Income Tax $9,288,000 $8,282,000 $5,939,000 $4,342,000
EAT $23,335,000 $3,436,000 $19,194,000 $2,022,000 INCOME STATEMENT RATIOS: Profitability (Earning Power)
Cash Dividends $9,334,000 $1,374,400 $7,677,600 $808,800 4 Gross Margin
Increase in RE $14,001,000 $2,061,600 $11,516,400 $1,213,200 Gross Profit ERROR:#DIV/0!
0.4 Sales
5 Net Margin
Balance Sheet Net Profit Before Tax ERROR:#DIV/0!
9/30/22 9/30/23 9/30/24 9/30/25 Sales
Current Assets:
Cash and Cash Equivalents $2,960,000 $1,156,000 $1,947,000 $1,520,000 ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios
Short Term Investments $9,858,000 $328,000 $185,000 $215,000 6 Sales-to-Assets
Net Receivables $41,114,000 $46,696,000 $40,716,000 $33,150,000 Sales ERROR:#DIV/0!
Inventory $19,593,000 $15,698,000 $11,617,000 $10,181,000 Total Assets
Total Current Assets $73,525,000 $63,878,000 $54,465,000 $45,066,000 7 Return on Assets
Net Profit Before Tax ERROR:#DIV/0!
Long Term Assets: Total Assets
Long Term Investments $26,165,000 $19,309,000 $18,637,000 $4,728,000 8 Return on Investment
Fixed Assets $85,947,000 $96,748,000 $91,911,000 $87,682,000 Net Profit Before Tax ERROR:#DIV/0!
Goodwill $10,542,000 $7,933,000 $10,838,000 $10,354,000 Net Worth
Intangible Assets $4,772,000 $4,204,000 $4,473,000 $5,128,000
Other Assets $1,508,000 $5,955,000 $1,139,000 $4,633,000 ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios
Deferred Asset Charges $5,307,000 $0 ($65,000) ($78,000) 9 Inventory Turnover
Total Assets $207,766,000 $198,027,000 $181,398,000 $157,513,000 Cost of Goods Sold ERROR:#DIV/0!
Inventory
Current Liabilities: 10 Inventory Turn-Days
Accounts Payable $52,380,000 $54,341,000 $41,128,000 $36,215,000 360 ERROR:#DIV/0!
Short Term Debt/Current Portion of Long Term Debt $18,015,000 $10,184,000 $9,456,000 $10,086,000 Inventory Turnover
Other Current Liabilities $1,602,000 $0 $0 $0 11 Accounts Receivable Turnover
Total Current Liabilities $71,997,000 $64,525,000 $50,584,000 $46,301,000 Sales ERROR:#DIV/0!
Accounts Receivable
Long Term Debt $13,926,000 $12,907,000 $12,869,000 $11,922,000 12 Accounts Receivable Turn-Days
Other Liabilities $12,017,000 $26,943,000 $21,783,000 $18,139,000 360 ERROR:#DIV/0!
Deferred Liability Charges $25,488,000 $15,050,000 $15,273,000 $13,514,000 Accts. Rec. Turnover
Minority Interest $789,000 $1,885,000 $1,125,000 $638,000 13 Accounts Payable Turnover
Total Liabilities $124,217,000 $121,310,000 $101,634,000 $90,514,000 Cost of Goods Sold ERROR:#DIV/0!
Accounts Payable
Shareholders Equity: 14 Average Payment Period
Preferred Stocks $0 $21,000 $0 $21,000 360 ERROR:#DIV/0!
Common Stocks $5,185,000 $5,382,000 $5,552,000 $5,595,000 Accts. Pay. Turnover ERROR:#DIV/0!
Capital Surplus $0 $6,366,000 $4,480,000 $4,243,000
Retained Earnings $78,364,000 $37,763,000 $38,700,000 $32,344,000
Negative Goodwill $0 $61,000 $0 $0
Other Equity $0 $27,124,000 $31,032,000 $24,796,000
Total Equity $83,549,000 $76,717,000 $79,764,000 $66,999,000
Total Liabilities/Equity $207,766,000 $198,027,000 $181,398,000 $157,513,000

B

Are you using the correct spreadsheet? This is Spreadsheet B.
The Bishop Companies, Incorporated Pro Forma Financial Statements
Income Statement
Period Ending: 9/30/22 9/30/23 9/30/24 9/30/25 RATIO ANALYSIS MATRIX
Net Sales $180,286,000 $232,671,000 $286,059,000 $245,386,000
Cost of Goods Sold $158,267,000 $203,752,000 $249,259,000 $188,312,000 BALANCE SHEET RATIOS: Stability (Staying Power)
Gross Profit $22,019,000 $28,919,000 $36,800,000 $57,074,000 1 Current
Current Assets ERROR:#DIV/0!
Operating Expenses: Current Liabilities
Sales, General and Admin. $13,276,000 $14,532,000 $14,950,000 $13,706,000 2 Quick
Non-Recurring Items $0 $17,000 ($1,510,000) $2,515,000 Cash + Accts. Rec. ERROR:#DIV/0!
Other Operating Items $0 ($1,714,000) $0 $8,771,000 Current Liabilities
EBIT $8,743,000 $16,084,000 $23,360,000 $32,082,000 3 Debt-to-Worth
Interest Expense $1,279,000 $851,000 $642,000 $559,000 Total Liabilities ERROR:#DIV/0!
EBT $7,464,000 $15,233,000 $22,718,000 $31,523,000 Net Worth
Income Tax $4,342,000 $5,939,000 $8,282,000 $9,288,000
EAT $3,122,000 $9,294,000 $14,436,000 $22,235,000 INCOME STATEMENT RATIOS: Profitability (Earning Power)
Cash Dividends $1,248,800 $3,717,600 $5,774,400 $8,894,000 4 Gross Margin
Increase in RE $1,873,200 $5,576,400 $8,661,600 $13,341,000 Gross Profit ERROR:#DIV/0!
0.4 Sales
5 Net Margin
Balance Sheet Net Profit Before Tax ERROR:#DIV/0!
9/30/22 9/30/23 9/30/24 9/30/25 Sales
Current Assets:
Cash and Cash Equivalents $1,520,000 $1,947,000 $1,156,000 $2,960,000 ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios
Short Term Investments $215,000 $185,000 $328,000 $9,858,000 6 Sales-to-Assets
Net Receivables $33,150,000 $40,716,000 $46,696,000 $41,114,000 Sales ERROR:#DIV/0!
Inventory $10,181,000 $11,617,000 $15,698,000 $19,593,000 Total Assets
Total Current Assets $45,066,000 $54,465,000 $63,878,000 $73,525,000 7 Return on Assets
Net Profit Before Tax ERROR:#DIV/0!
Long Term Assets: Total Assets
Long Term Investments $4,728,000 $18,637,000 $19,309,000 $26,165,000 8 Return on Investment
Fixed Assets $87,682,000 $91,911,000 $96,748,000 $85,947,000 Net Profit Before Tax ERROR:#DIV/0!
Goodwill $10,354,000 $10,838,000 $7,933,000 $10,542,000 Net Worth
Intangible Assets $5,128,000 $4,473,000 $4,204,000 $4,772,000
Other Assets $4,633,000 $1,139,000 $5,955,000 $1,508,000 ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios
Deferred Asset Charges ($78,000) ($65,000) $0 $5,307,000 9 Inventory Turnover
Total Assets $157,513,000 $181,398,000 $198,027,000 $207,766,000 Cost of Goods Sold ERROR:#DIV/0!
Inventory
Current Liabilities: 10 Inventory Turn-Days
Accounts Payable $36,215,000 $41,128,000 $54,341,000 $52,380,000 360 ERROR:#DIV/0!
Short Term Debt/Current Portion of Long Term Debt $10,086,000 $9,456,000 $10,184,000 $18,015,000 Inventory Turnover
Other Current Liabilities $0 $0 $0 $1,602,000 11 Accounts Receivable Turnover
Total Current Liabilities $46,301,000 $50,584,000 $64,525,000 $71,997,000 Sales ERROR:#DIV/0!
Accounts Receivable
Long Term Debt $11,922,000 $12,869,000 $12,907,000 $13,926,000 12 Accounts Receivable Turn-Days
Other Liabilities $18,139,000 $21,783,000 $26,943,000 $12,017,000 360 ERROR:#DIV/0!
Deferred Liability Charges $13,514,000 $15,273,000 $15,050,000 $25,488,000 Accts. Rec. Turnover
Minority Interest $638,000 $1,125,000 $1,885,000 $789,000 13 Accounts Payable Turnover
Total Liabilities $90,514,000 $101,634,000 $121,310,000 $124,217,000 Cost of Goods Sold ERROR:#DIV/0!
Accounts Payable
Shareholders Equity: 14 Average Payment Period
Preferred Stocks $21,000 $0 $21,000 $0 360 ERROR:#DIV/0!
Common Stocks $5,595,000 $5,552,000 $5,382,000 $5,185,000 Accts. Pay. Turnover ERROR:#DIV/0!
Capital Surplus $4,243,000 $4,480,000 $6,366,000 $0
Retained Earnings $32,344,000 $38,700,000 $37,763,000 $78,364,000
Negative Goodwill $0 $0 $61,000 $0
Other Equity $24,796,000 $31,032,000 $27,124,000 $0
Total Equity $66,999,000 $79,764,000 $76,717,000 $83,549,000
Total Liabilities/Equity $157,513,000 $181,398,000 $198,027,000 $207,766,000

C

Are you using the correct spreadsheet? This is Spreadsheet C.
The Bishop Companies, Incorporated Pro Forma Financial Statements
Income Statement
Period Ending: 9/30/22 9/30/23 9/30/24 9/30/25 RATIO ANALYSIS MATRIX
Net Sales $232,471,000 $245,186,000 $180,076,000 $286,059,000
Cost of Goods Sold $203,752,000 $188,312,000 $158,267,000 $249,259,000 BALANCE SHEET RATIOS: Stability (Staying Power)
Gross Profit $28,719,000 $56,874,000 $21,809,000 $36,800,000 1 Current
Current Assets ERROR:#DIV/0!
Operating Expenses: Current Liabilities
Sales, General and Admin. $14,532,000 $13,706,000 $13,276,000 $14,950,000 2 Quick
Non-Recurring Items $17,000 $2,515,000 $0 ($1,510,000) Cash + Accts. Rec. ERROR:#DIV/0!
Other Operating Items ($1,714,000) $8,771,000 $0 $0 Current Liabilities
EBIT $15,884,000 $31,882,000 $8,533,000 $23,360,000 3 Debt-to-Worth
Interest Expense $851,000 $559,000 $1,279,000 $642,000 Total Liabilities ERROR:#DIV/0!
EBT $15,033,000 $31,323,000 $7,254,000 $22,718,000 Net Worth
Income Tax $5,939,000 $9,288,000 $4,342,000 $8,282,000
EAT $9,094,000 $22,035,000 $2,912,000 $14,436,000 INCOME STATEMENT RATIOS: Profitability (Earning Power)
Cash Dividends $3,637,600 $8,814,000 $1,164,800 $5,774,400 4 Gross Margin
Increase in RE $5,456,400 $13,221,000 $1,747,200 $8,661,600 Gross Profit ERROR:#DIV/0!
0.4 Sales
5 Net Margin
Balance Sheet Net Profit Before Tax ERROR:#DIV/0!
9/30/22 9/30/23 9/30/24 9/30/25 Sales
Current Assets:
Cash and Cash Equivalents $1,947,000 $2,960,000 $1,520,000 $1,156,000 ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios
Short Term Investments $185,000 $9,858,000 $215,000 $328,000 6 Sales-to-Assets
Net Receivables $40,716,000 $41,114,000 $33,150,000 $46,696,000 Sales ERROR:#DIV/0!
Inventory $11,617,000 $19,593,000 $10,181,000 $15,698,000 Total Assets
Total Current Assets $54,465,000 $73,525,000 $45,066,000 $63,878,000 7 Return on Assets
Net Profit Before Tax ERROR:#DIV/0!
Long Term Assets: Total Assets
Long Term Investments $18,637,000 $26,165,000 $4,728,000 $19,309,000 8 Return on Investment
Fixed Assets $91,911,000 $85,947,000 $87,682,000 $96,748,000 Net Profit Before Tax ERROR:#DIV/0!
Goodwill $10,838,000 $10,542,000 $10,354,000 $7,933,000 Net Worth
Intangible Assets $4,473,000 $4,772,000 $5,128,000 $4,204,000
Other Assets $1,139,000 $1,508,000 $4,633,000 $5,955,000 ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios
Deferred Asset Charges ($65,000) $5,307,000 ($78,000) $0 9 Inventory Turnover
Total Assets $181,398,000 $207,766,000 $157,513,000 $198,027,000 Cost of Goods Sold ERROR:#DIV/0!
Inventory
Current Liabilities: 10 Inventory Turn-Days
Accounts Payable $41,128,000 $52,380,000 $36,215,000 $54,341,000 360 ERROR:#DIV/0!
Short Term Debt/Current Portion of Long Term Debt $9,456,000 $18,015,000 $10,086,000 $10,184,000 Inventory Turnover
Other Current Liabilities $0 $1,602,000 $0 $0 11 Accounts Receivable Turnover
Total Current Liabilities $50,584,000 $71,997,000 $46,301,000 $64,525,000 Sales ERROR:#DIV/0!
Accounts Receivable
Long Term Debt $12,869,000 $13,926,000 $11,922,000 $12,907,000 12 Accounts Receivable Turn-Days
Other Liabilities $21,783,000 $12,017,000 $18,139,000 $26,943,000 360 ERROR:#DIV/0!
Deferred Liability Charges $15,273,000 $25,488,000 $13,514,000 $15,050,000 Accts. Rec. Turnover
Minority Interest $1,125,000 $789,000 $638,000 $1,885,000 13 Accounts Payable Turnover
Total Liabilities $101,634,000 $124,217,000 $90,514,000 $121,310,000 Cost of Goods Sold ERROR:#DIV/0!
Accounts Payable
Shareholders Equity: 14 Average Payment Period
Preferred Stocks $0 $0 $21,000 $21,000 360 ERROR:#DIV/0!
Common Stocks $5,552,000 $5,185,000 $5,595,000 $5,382,000 Accts. Pay. Turnover ERROR:#DIV/0!
Capital Surplus $4,480,000 $0 $4,243,000 $6,366,000
Retained Earnings $38,700,000 $78,364,000 $32,344,000 $37,763,000
Negative Goodwill $0 $0 $0 $61,000
Other Equity $31,032,000 $0 $24,796,000 $27,124,000
Total Equity $79,764,000 $83,549,000 $66,999,000 $76,717,000
Total Liabilities/Equity $181,398,000 $207,766,000 $157,513,000 $198,027,000
error: Content is protected !!