1 Open the downloaded file, GolfSales.xlsx . Save the workbook as GolfSales_LastFirst using your last and first name. If a Security Warning message displays, click the Enable Editing button. 2 On the...

RISING_STAR company was incorporated in the first of June 2020. Money was raised at that time with total $1000 which include 30% from bank loan, 30% from corporate bond and the rest from its own...

Quarter Lawn Mowers Snow Blowers 1 10,000 9,000 2 15,000 7,000 3 16,000 19,000 4 3,000 10,000 Quarter 1 Beginning inventory: Mowers 600 Blowers 400 Output and Costs Regular Time = $5.00 per unit...

It is March 15, 2021. Ajayas income from employment for the 2020 taxation year is $100,000. She does not earn commission income, and has no other sources of income. She operates out of her home...

Ursula Chang works as a Senior Account Manager for Decorous Stone and Tile (Deco), a Canadian public company. Her responsibilities include selling tiling products to various retailers across North...

The Jacksons want to know the amount of required capital that will be needed to have accumulated at retirement to supplement their assumed Social Security to support their retirement goal? Assume...

Directions: Read each question carefully. SHOW ALL WORK! Label your answer clearly. WEIGHTED AVERAGE COST OF CAPITAL P&G . Peafiel and Godoy have an optimal capital structure that consists of...

Advice on company franking account and distributions Cynthia and Andreas seeking your advice regarding Border Pty Ltds franking account. (Please note: use all figures/information provided from...

Ava has asked you to help prepare her 2021 personal income tax returns (combined Federal and Quebec). For 2021, she provided you with the following: 14 tax slip from Hydro-Qubec where she works as...

A company has developed a promising new product and examines the following three alternatives of manufacturing. Alternative No. 1 is to buy a semi-automatic machine with an initial cost of 130,000,...

Calculate the expected utility for both investors if they invested solely in each industry. Which industry does each investor prefer? What are the reasons for their preference? Consider the MATL and...

Del Arbr Ltd (hereafter referred to as "DA") is a property development company listed on the JSE. The company was founded by Mr Labuschagne and Mr Kaiser in 1974 and has since grown to be one of the...

Suppose that Ms. Smart invests 25% of her portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the first table below. The correlations...

Kushla is an INFOSEC administrator for a company with 500 employees, this is an ongoing job (not a short contract) and she wishes to stay at this company for a long time. Her manager, Kevin gives her...

Tril owns a fleet of light delivery vehicles (aka bakkie). One of his delivery vehicles with a market value of R170 000, which had originally cost R190 000 on 1 March 2020 was exactly two years old...

A company has issued $75 million (face value) of bonds with three years to maturity. They offer an annual coupon of 2.46% above the sixth-month $LIBOR. Interest is paid every six months and the...

GWE in store retail is considering closing stores to save a further 20% next year. Given current figures, how many stores would you expect GWE to close? GWE Profit and Loss for (Year 1) Asia...

Eastern Publishers Ltd (EPL) is preparing its December 31, 2020, year-end financial statements. EPL focuses on corporate clients by binding and publishing corporate directories, policy manuals, and...

Mohawk Ltd. is a private corporation. Below are some activities for their year ended December 31, 2023: Net income after taxes for 2023 totaled $75,000. Declared and issued a two-for-one stock split....

An investment requires $16,000 today, and produces the first cash flow of $800 in two years (year 2). Cash flow is expected to grow at 2% per year after year 2. a) What is the NPV of this investment...

You are a financial analyst at a firm that has been returning cash to shareholders through stock repurchases. You want to determine how the level of repurchases will vary as a function of the sales...

Mr. Musk is issuing today 3 percent annual coupon bond for 1000. The bond has 10 years to maturity. You are a conservative investor, and believe that bonds are less risky than stocks, so you decide...

A food manufacturing company, Goodies Ltd, develops, manufactures, and sells health food bars. Goodies are now considering entering the home health equipment market and wish to develop a new brand...

The GFA Company, originally established 16 years ago to make football, is now a leading producer of tennis balls, baseballs, footballs, and golf balls. Nine years ago, the company introduced High...

Please complete Queen Bee Plumbings 2020 tax return based upon the facts presented below. If required information is missing, use reasonable assumptions to fill in the gaps. Ignore all AMT...

Wheeler Electrical Supplies, Inc. (Wheeler), an accrual basis, calendar year C corporation, has been in the business of manufacturing small electrical components in Texas since 1983. Until recently,...

Roadrunner Bookstore uses the perpetual inventory system. Roadrunner Bookstore is owned by Tina Smith. The company had the following transactions for the month of November. Nov 1 Nov 2 Nov 3 Nov 5...

The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of...

Reported in the table below are estimation results for three residential housing price models. The dependent variable is defined as home sales price measured in thousands of dollars. The models...

A new instrument capable of performing 40,000 tests per year has a purchase price of $15,000,000. The installation will cost 10% of the purchase price. The manufacturer covers maintenance costs for...

Davidson Food Processing Company produces its popular brand of boneless canned chicken (Chickn Good) at its plant in Iowa. On the average, a 3-pound (48 ounces) chicken can be purchased by the firm...

The market demand for a good is given by the demand function: QD=48-2P The market supply curve for the good is given by Qs=12P-2 i) What is the sellers reservation price for the good? ii) Find the...

The following investments are available to you: (a) a taxable bond with a coupon rate of 5% per year; (b) a tax-exempt bond with a coupon rate of 3% per year; and (c) preferred (qualified) stock that...

Sunny Inc. is trying to decide whether investing in Project A is a good idea. This project will last 5 years and will not exist after that. Any salvage value will be considered as an additional cash...

It's STILL January 1, 2023, and you'll be going on Shark Tank in 2 weeks. You are unhappy with your previous Sales Forecast because your current sales to residences do not really predict your...

Using historical risk premiums from Table 5.5 over the 1927-2018 period as your guide, what would be your estimate of the expected annual HPR on the Big/Value portfolio if the current risk-free...

Obtain from Bloomberg the end of year values for the period 20102021 of both FTSE100 (UKX) Index and S&P500 (SPX) Index. Assume that you are a risk-averse investor. Explore the risk-return...

You will use the three-stage DDM with a linearly declining growth rate in stage 2 to compute the intrinsic value of Walt Disney stock by employing the information in the picture below: You are...

ABC Holdings is a publicly traded company with only two assets: It owns 60% of Tims Supply Shop and 100% of the Caribou Coat Factory. Suppose the market value of ABC Holdings is $160 million, and the...

Janet just graduated from college, has a job she's scheduled to begin in 3 months and has decided to treat herself to 6 weeks of travel across South America before she buckles down and starts working...

Suppose Bank A has $40 million in rate-sensitive assets, $70 million in fixed rate assets, $70 million in rate sensitive liabilities, and $40 million in fixed rate liabilities and equity capital. (8...

h) I proceed to study the short-run dynamic of the changes in gold price (LGPRICE) and inflation (INF) and estimated a VAR model. Write down the VAR(1) model using the notation LGPRICE and INF? (j)...

Use the following information to answer Questions: (i) Based on an engineering study completed a year ago at a cost of $50,000. Mohammed Company is considering whether to construct a new production...

You are buying a new car for $30,000 plus 5% taxes for a total cost of $31,500. You can pay cash for the entire amount by writing a check from your money market deposit account at the bank that...

On June 24, 2021, Erika purchased a duplex with the intent of renting both units. The seller, Emanuel, had fallen behind on payments, so Erika paid Emanuel $50,000 in cash and assumed the $225,000...

Edinaman Company (Edinaman) currently processes seafood with a unit purchased several years ago. The unit which originally cost $500,000, currently has a book value of $250,000. Edinaman is...

Ben Gualita, vice-president of seles, has recommended adding a new product line. A market Study and cost analyses show that the new line should yield the following annual results. Net Sales Cost of...

Cooper's Copper Roofs (CCR) has entered into a production contract for a housing development. The contract calls for CCR to install copper roofs on 100 new homes. Each roof requires 1,000 pounds of...

XYZ Company is considering a new project with a cost of $25,000 and a life of 5 years. The projects yearly pretax operating cash revenues and expenses are $20,000 and $9,000, respectively. The...

Based on the information in the project dashboards for each of the projects, which projects would you recommend, and Why? See [Exhibit TN-3] as an example. Which project attributes did you put more...

1 . Consider an all-equity financed firm. The firm has a beta of 1.1, the risk-free rate is 2%, and the market risk premium is 4%. What is the firm's WACC? (Assume the CAPM holds.) 2 . Consider a...

The Montclair State University endowment has a commitment to fund two initiatives as described below. As a hedge to these commitments, it entered into three forward contracts with cash flows also...

You think the price of AMZN stock, which is currently $900 is likely to change significantly over the next three months, you are just not sure which direction. So you buy a long straddle position,...

Traditionally firms raise capital in the primary market issuing either fixed or floating rate debt. Both bond structures expose the firm to interest rate risk. The financial derivatives market...

1. XYZ Ltd. ("XYZ") yesterday issued a $1,000 par value 5 year bond ("the Bond"), In evaluating any capital budgeting proposal, XYZ has, historically, utilized a Required Rate of Return of 25%. As a...

A potential buyer has visited a brokerage to talk to an agent about the pros and cons of buying a home vs. renting one. The agent asks the potential buyer questions about the buyer's income, price...

What are your own feelings about credit scores and how they are used in our society? Do you think they are accurate? Fair/just? Perpetuating inequality? Explain your reasoning. In the sim, once you...

An LBO group is making an offer to purchase a target company. The company's current stock price is $9.50 per share, and the company has 250 million shares outstanding; the company currently has...

Establishing rapport is a crucial step at the enquiry and interview stage. In preparing for your interview and meeting this client for the first time, list 10 ways you will aim to both establish...

A company has the following profile. Solve/respond to the the questions below. Please show your calculations for partial credit. Net Income - $375,000 Bank Debt - $1,000,000 @ 6% Equity - $3,000,000...

Raleigh Medical Clinic is considering acquiring 2 new ultrasound machines for $300,000. The clinic estimates that the machines will have an economic life of 4 years after which they will have zero...

From random sample, here is mean and SD of NFL total salary in 2009. Sample size is 201. 1) Is the sample size adequate to find a total salary? 2) Is the sampling method appropriate to find total...

Chris (for Christine or Christopher) and Sam (for Samuel or Samantha) are a couple who live in Toronto and are somewhat recent graduates from George Brown. They each earn $60,000 per year. And both...

For the Buffett's Bid for Media General's Newspapers Case: In order to value the small market newspaper assets of MEG being purchased, you need to establish an appropriate risk adjusted discount...

Consider the calculation of the continuation value. Suppose Firm C has a WACC of 7%. Firm C's investment banker prepares a DCF valuation of Firm C using the WACC ap- proach. In her DCF valuation,...

Dafa Ltd is a trading company dealing in a single product. It is preparing its annual budget for the twelve months ending 30th June 2021. So far, the following budgets have been prepared: ITEM...

You have a portfolio with three assets. The forecasted inputs are showed in following table: a. Calculate expected marginal contribution to total risk (MCTR) and absolute contribution to total risk...

The finance department has estimated that a discount rate of 13 percent should be used. If unsuccessful, after the first year the project can be dismantled and will have an aftertax salvage value of...

Investor can make investments in 5 types of stocks. According to the available data (relating to the past), estimates of the mean values (mathematical expectations) and standard deviations of annual...

Paul V. Dietrich Farms Ltd.: Expansion Plan In November 2020, Paul Dietrich, a seventh-generation Canadian farmer, was presented with an investment opportunity. A local farmland owner was selling a...

Calculate the weights of VBTLX and VFIAX that achieve a portfolio allocation that represents an "optimal risky portfolio" on the efficient frontier, as of the end of December 2015. Given these...

Bintumani Mountain Apparatus Inc. produces tents at variable costs of $56 per tent. The fixed costs for the production are $99,850. The company sells tents to outdoor stores for $149 per tent. a) How...

Using the HCF Balance Sheet on page 226-227 in Table 9A-1, how could you determine the amount of debt principal that will be retired during the next fiscal year? TABLE 9A-1 Harris Memorial Hospital...

Kiss Cosmetics Inc. has a 4-year 5% coupon bond (annual coupon payments) with a face value of $1,000. The spot rate term structure is shown in the table below. A) Calculate the discount factors, PV...

Your 21-year old cousin is graduating from college and has already accepted her first full-time job offer. She will be earning $3,000 per month. She already has an apartment and her fixed monthly...

Using the accompanying Retirement_Calculator spreadsheet model, Claire wants to use Scenario Manager to compare the following retirement saving scenarios: Click here for the Excel Data File Scenario...

You are almost finished with your internship and your hard work has been noticed! For the third part of your project, you have been promoted to Senior Intern. The hospital Chief Financial Officer...

(Round your calculations to 4 decimal places.) (Note: If you invest equal dollar amounts in the 4,400 stocks traded publicly in the US, the X i of any stock is 1/4400 or 0.000227.) You are curious...

Donovan Ramsey, the Chief Financial Officer of LevelUp Business Consulting, has advised you that the company is considering closing its Calgary, Alberta office and transitioning the staff of that...

The case puts you in the shoes of a research analyst who is examining the jet fuel hedging strategy of JetBlue Airways for the coming year 2012. Airlines cross-hedge their jet fuel price risk using...

Dan and Susan are faced with an important decision. After having discussed different financial scenarios, the two computer engineers felt it was time to finalize their cash flow projections and move...

Ashton Home Furnishings manufactures hutches, tables, and beds in a modern plant located in beautiful, historic Ashton. The following sales and cost information is available relating to the...

A columnist made the following comment in an online article: "In any case, the Q-factor approach, unlike consumption CAPM, explains where the anomalies come from (and why they might end). Consumption...

Create Strategic Asset Allocation for the hypothetical investor Your first client is Jim and Karla Sanders who are 25 and 22, respectively. Jim and Karla have been married for two years and have a...

The cost of a single RD-6 satellite is $350 million. A MK-8 imaging satellite carries a price tag of $300 million. Another significant factor with satellites is the cost of the launch. In particular,...

You are a financial advisor working in Scarborough, Ontario. One day, you get a phone call from Priya Patel and you arrange a first meeting with her. You find out that she is a referral from one of...

The first table presents multiples for peers of Firm X and the second table presents information for Firm X. Peer EV/EBITDA EV/EBIT EV/Revenue P/E P/B Firm A 7.53 7.78 0.61 11.43 3.29 Firm B 9.26...

Lee plans to retire in 22 years with a nest egg of $5M. He has already saved up $300,000 in an investment account that generates an annual rate of return of 12.6%, compounded daily. Assume 360-day...

You are a pension consultant who was recently engaged by Awesome Benefit Company (ABC) to become the valuation actuary for their frozen defined benefit pension plan. You have also been hired to help...

1. You borrow $50,000 for 5 years. This is an amortized load, meaning that payments are the same each month, and the loan is fully paid off with final payment. The quoted interest rate (or APR) is...

On 8 November 2022, Zandile Zungu acquired twenty South African treasury bonds that pays semi-annual interest at a current price (present value) of 117% of R1 000 par value per bond. The last coupon...

Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail business is led by Canadian...

Jamie Lynn is the revenue manager at a 250room fullservice hotel property. Her comp set includes five full and limitedservice properties: The demand and revenue performance of Jamie Lynn's hotel for...

A company wishes to create a trust fund through a savings plan with either annual or monthly deposits under an APR of 5% over 30 years. During that time, the company has the following cash flows: a...

Amadeus Corporation is considering the issue of a new product to be added to its product mix. They hired you, a recent business graduate from MacEwan, for conducting the analysis. The production line...

You are the manager of a technology fund that has an expected rate of return of 7.60% and a standard deviation of 15.50%. The T-bill rate is 2.75% and your fund is currently invested in the following...

Your company is considering acquiring a private company (New Co., Inc.). The CFO has asked you to review the financial statements, look for key trends, and develop financial/operational questions to...

You have just been offered a full-time position in Cambridge and want to live close to where you will be working.The picture shows a condo currently listed for sale at $575,000 in Cambridge.It last...

Textflix is a new idea to help reduce college student cost of textbooks. Textflix is a new project to be undertaken by the Netflix Corporation. Textflix will charge $20 per month to have access to a...

Capital Structure Project - W. M. Wrigley Jr.(10pts * 6 = 60 pts) For this project, please use Excel to do your calculations and analysis and then type a report in MS Word. Your report should clearly...