FIN 571 Week 1 Connect Problems (Math and Accounting Review)
$8.00

FIN 571 Week 1 Connect Problems (Math and Accounting Review)

This Tutorial was purchased 9 times & rated A+ by student like you.

 

This Tutorial contains following Attachments

  • FIN 571 Week 1 Connect Problems (Math Accounting Review).docx

FIN 571 Week 1 Connect Problems (Math & Accounting Review) 1. Functions Excel will make your life as a finance student much easier. This section will show how to use various functions in Excel. Once you understand the how and why of a particular financial equation, you can make 1. Which Excel cell entry will calculate the square root of 165? 2. Which statements about Excel’s FV function are correct? 3. Which fields are required to calculate net present value (NPV) in Excel? 4. Which Excel function is used to calculate the amount of each annuity payment? 5. Which fields are required to calculate the rate of return (RATE) for a present value calculation in Excel? 2. The Balance Sheet This lesson will help you refresh your knowledge on the basics of the balance sheet. Brushing up on these concepts now will help you tackle your finance coursework later. General Ledger for XYZ Company. The following is a portion of the general ledger for XYZ Company as of December 31, 20X1, and the statement of stockholders’ equity for XYZ Company for the year ended December 31, 20X1. Use this information to answer questions (1) through (5). 1. What is the total amount of current assets to be reported on XYZ Company’s 12/31/X1 classified balance sheet? 2. What is the total amount of long-term assets to be reported on XYZ Company’s 12/31/X1 classified balance sheet? 3. What is the total amount of current liabilities to be reported on XYZ Company’s 12/31/X1 classified balance sheet? 4. What is the ending balance in retained earnings to be reported on XYZ Company’s 12/31/X1 classified balance sheet? 5. What is the total amount of stockholders’ equity to be reported on XYZ Company’s 12/31/X1 classified balance sheet? 3. Calculating Interest This lesson will help fill in the basics on how to calculate interest when tackling financial problems. 1. What is the amount of interest earned after two years on a $100 deposit paying 4 percent simple interest annually? 2. What is the amount of compound interest earned after three years on a $100 deposit paying 8 percent interest annually? 3. A business just took out a loan for $100,000 at 10% interest. If the business pays the loan off in three months, how much did the business pay in interest? 4. What is the annual percentage yield (APY) for a deposit paying 5 percent interest with monthly compounding? 4.The Income Statement This lesson will help you refresh your knowledge on the basics of the income statement. Brushing up on these concepts now will help you tackle your finance coursework later. General Ledger for ABC Company. The following is the general ledger for ABC Company as of December 31, 20X1. Use this information to answer questions (1) through (4). 1. What is the amount of gross profit to be reported on ABC Company’s 12/31/X1 income statement? 2. What is the amount of operating income (EBIT) to be reported on ABC Company’s 12/31/X1 income statement? 3. What is the amount of earnings before taxes (EBT) to be reported on ABC Company’s 12/31/X1 income statement? 4. What is the amount of net income to be reported on ABC Company’s 12/31/X1 income statement? 5. Fractions and Decimals This lesson will help you review fractions and decimals: calculating, converting, and recognizing how to use them in a financial setting. 1. 54/32 converted to a mixed number is ________. 2. The product of one and four thirty-seconds and twenty thirty-seconds is ________. 3. One and eight thirty-seconds divided by twelve thirty-seconds is ________. 4. A U.S. Treasury bond is trading at 98 and 6/32. Convert this price to its decimal form. 5. What is the percentage increase if the S&P 500 Index is currently trading at 1,100 and rises 55 points? 6. Exponential Functions This lesson will help you refresh your skills using exponents. Many financial equations rely on exponents to show compounding and growth. 1. A business acquaintance promises to deliver a $20 bill to you one year from today. How much should you be willing to pay today for this promise? 2. What is the present value of $1,000 received three years from today if interest rates are currently 6 percent? 3. What is the interest rate on a three-year investment with a future value of $1000 and a present value of $863.84? 4. The product rule of exponents says that when multiplying two powers that have the same base, you need to ________. 5. The fifth root of fifteen is equal to ________. 7. Basic Math This section of the tutorial will cover writing and editing formulas, using cell references, following the order of operations, and using operators. 1. Which of the following Excel cell entries gives the sum of 20 + 150 + 85? 2. Which letter or symbol does Excel use to multiply numbers? 3. What is the correct order of operations for entering formulas into Excel? 4. Which of the following sequences will give you the square root of 25 in Excel? 5. Suppose you need to add the values in range of cell from C2 through C8. Which of the following sequences will give you the correct answer? 8. Organizing Data This tutorial is designed to help you to successfully utilize Microsoft Excel in your finance courses. 1. You are working on an Excel table and realize that you need to add a row to the middle of your table. What is one way to do this? 2. You are working on an Excel table and realize that you need to add a single cell to your table. What is one way to do this? 3. You are working on an Excel table and realize that you need to delete a column in the middle of your table and shift the remaining data columns to the left. What is one way to do this? 4. You are valuing an investment that will produce cash flows of $10,000 each year for 15 years. What is the quickest way to enter $10,000 into each of the 15 cells of your table? 5. You have three tables in a worksheet in Excel. You need to sort one of the tables numerically, from smallest to largest values. How can you do this? 9. Solving for the Unknown This lesson will help you review how to solve for unknown quantities in a problem. 1. If the future value of a one-period investment is given by the formula, F = I + (I × R), what is the formula for the amount of the investment, I? 2. The opposite process rule says to solve for ________. 3. When solving for an unknown that involves more than one process, the multiple process rule requires that ________. 4. If the future value of a one-period investment is given by the formula, F = I + (I × R), what is the formula for the rate of interest, R? 5. If the bank returns $50 on a $1,000 deposit after one year, what is the interest rate earned on this deposit? 10. Accounting Concepts This lesson will help you refresh the basic accounting concepts. 1. ________ are items owed to a creditor. ________ are items owned by a company. ________ represents owners' claims to company resources. 2. Under ________ accounting, revenues are recorded when earned and expenses are recorded with related revenues. Under ________ accounting, revenues are recorded when cash is received and expenses are recorded when cash is paid out. Financial statements are prepared using ________ accounting. 3. The ________ retains the power and authority to set accounting standards. Currently, this responsibility has been delegated to the________. 4. In what order are the four primary financial statements prepared? 5. The difference between net income and dividends paid is known as what?

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$3.00

This Tutorial was purchased 1 times & rated No rating by student like you.

The development of the new issue junk bond market had important implications for capital structure choice. The existence of a viable junk bond market means that firms can comfortably maintain higher degrees of leverage than they could prior to the development of this market. Do you agree or disag..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

Because the weighted average is always a correct measure of a required return, why do firms not create securities to finance each project and offer them in the capital market in order to accurately determine the required return for the project? ..
$3.00

This Tutorial was purchased 1 times & rated No rating by student like you.

Phyllis believes that the firm should use straight-line depreciation for a capital project because it results in higher net income during the early years of the project’s life. Joanna believes that the firm should use the modified accelerated cost recovery system depreciation because it reduces t..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

A firm uses a single discount rate to compute the NPV of all its potential capital budgeting projects, even though the projects have a wide range of nondiversifiable risk. The firm then undertakes all those projects that appear to have positive NPVs. Briefly explain why such a firm would tend to ..
$3.00

This Tutorial was purchased 0 times & rated No rating by student like you.

Optical Supply Company offers credit terms of 2/10, net 60. If Optical Supply is considering a change in its credit terms to one of those indicated, explain whether the change should increase   or decrease sales. (a) 2/10, net 30, (b) net 60, (c) 3/15, net 60, (d) 2/10, net 30, 30 extra..
$3.00

This Tutorial was purchased 2 times & rated A by student like you.

Why are interest rates on short-term loans not necessarily comparable to each other? Give three possible reasons. ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

Suppose rf is 5% and rM is 10%. According to the SML and the CAPM, an asset with a beta of −2.0  has a required return of negative 5% [= 5 − 2(10 − 5)]. Can this be possible? Does this mean that  the asset has negative risk? Why would anyone ever invest in an asset that has an e..
$3.00

This Tutorial was purchased 1 times & rated A+ by student like you.

In order to receive proper credit, please reply to this message when posting your answers to WK2 DQ1.            Suppose you own $1 million worth of 30-year Treasury bonds. Is this asset riskless?        ..
$3.00

This Tutorial was purchased 0 times & rated A+ by student like you.

Assume that interest rates have increased substantially. Would this tend to increase or decrease      the market value (meaning the price an investor in the firm's paper is willing to pay) of a firm’s liabilities (relative to the book value of liabilities)?  ..
$3.00

This Tutorial was purchased 2 times & rated A+ by student like you.

What is ethics? If you follow all applicable rules and regulations, are you an ethical person? ..
$7.00

This Tutorial was purchased 20 times & rated A+ by student like you.

Resources: Harvard Business Publishing: Working Capital Simulation: Managing Growth Assignment Ch. 1 - 21 ofFundamentals of Corporate Finance WileyPLUS Assignments All additional resources from each week  Review the following scenario:  Acting as the CEO of a sm..
$4.00

This Tutorial was purchased 6 times & rated A+ by student like you.

Watch the "Corporate Finance Video: Stable Money Makers" located in the WileyPLUS Assignment: Week 6 Videos Activity. Identify a capital improvement that could help Betty with her Alpaca business. Write a summary of no more than 700 words explaining how the capital improvement you identif..
$5.00

This Tutorial was purchased 11 times & rated A+ by student like you.

Watch the "Concept Review Video: Cost of Capital" video located in the WileyPLUS Assignment: Week 5 Videos Activity. Discuss some of the corporate finance challenges faced by this company. Write a 350-700 word summary of your discussion. Click the Assignment Files tab to submit your a..
$5.00

This Tutorial was purchased 5 times & rated A+ by student like you.

Watch the "Concept Review Video: Stock Valuation" video located in the WileyPLUS Assignment: Week 4 Videos Activity. Discuss how markets and investors value a stock. Write a 350-700 word summary of your discussion. Click the Assignment Files tab to submit your assignment. ..
$8.00

This Tutorial was purchased 24 times & rated A by student like you.

Decide upon an initiative you want to implement that would increase sales over the next five years, (for example, market another product, corporate expansion, and so on). Using the sample financial statements, create pro forma statements of five year projections that are clear, concise, and e..
$4.00

This Tutorial was purchased 8 times & rated A+ by student like you.

Watch the "Concept Review Video: Working Capital Management" video located in theWileyPLUS Assignment: Week 3 Videos Activity.   Discuss strategies these business owners used to manage their working capital. Write a 350-700 word summary of your discussion. Click the Assignmen..
$8.00

This Tutorial was purchased 17 times & rated A by student like you.

Resource:  Financial Statements for the company assigned by your instructor in Week 2. Review the assigned company's financial statements from the past three years. Calculate the financial ratios for the assigned company's financial statements, and then interpret those results agains..
$4.00

This Tutorial was purchased 2 times & rated A+ by student like you.

Read the Ethics case, "A Sad Tale: The Demise of Arthur Anderson" located in the WileyPLUS Week Fundamentals of Corporate Finance Chapter readings. Discuss the mistakes made by Arthur Anderson and potential actions that leadership could have taken to prevent the organizational failure. Wr..
$8.00

This Tutorial was purchased 10 times & rated A by student like you.

Write a 350 to 700 word response to the following e-mail: Dear Consultant, I am currently starting a business and developing my business plan. I'm in need of some advice on how to start forming my business. I am not sure exactly how it will be financed and whether or not I want to take on..
$7.00

This Tutorial was purchased 5 times & rated A by student like you.

Watch the "Your Business Structure" and "Corporate Business Structures" videos on the Electronics Reserve Readings page. Identify the different business structures. Write a 350 to 700 word explanation of how each business structure might and might not be advantageous. Click the Assign..
$8.00

This Tutorial was purchased 3 times & rated A by student like you.

Discounted Cash Flows and WACC Homework Problems   Please post the answers (and show your work) in the assignments section by midnight the last day of the week assigned.     Calculate the future value of 1,535 invested today for 8 years at 6 percent. (..
$7.00

This Tutorial was purchased 4 times & rated A+ by student like you.

Operating Leverage and Forecasting Problems Team Assignment Please complete the following problems.  When calculating earnings per share and PE ratios, please show your work.  This problem is similar to the examples shown in the lecture. You manufacture hunting pack systems ..
$8.00

This Tutorial was purchased 4 times & rated A+ by student like you.

Ratio Analysis Problems Ratio Analysis (Individual Assignment)  You may use excel or word.doc format for this assignment. Please post your homework as a word.doc or excel file in the class discussion section below by the due date. 1.  Analysis of cost of goods sol..
$10.00

This Tutorial was purchased 7 times & rated A by student like you.

FIN 571 Week 4 Connect Problems Q-1 Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of €1,000, 20 years to maturity, and a coupon rate of..
$12.00

This Tutorial was purchased 6 times & rated A+ by student like you.

FIN 571 Week 3 Connect Problems If the Garnett Corp. has a 15 percent ROE and a 25 percent payout ratio, what is its sustainable growth rate? 1.If the Hunter Corp. has an ROE of 15 and a payout ratio of 18 percent, what is its sustainable growth rate 2.The most recent financial statements..
$10.00

This Tutorial was purchased 18 times & rated A+ by student like you.

The Sarbanes-Oxley Act of 2002 (SOX) was passed as the result of the Enron scandal and other instances of accounting fraud. This act was passed to strengthen the role of the Securities and Exchange Commission (SEC). Research a case of corporate financial abuse related to the Sarbanes-Oxley Act o..
$12.00

This Tutorial was purchased 8 times & rated A+ by student like you.

FIN 571 Week 2 Connect Problems 1.Sankey, Inc., has current assets of $4,230, net fixed assets of $25,700, current liabilities of $3,500, and long-term debt of $14,400. What is the value of the shareholders' equity account for this firm? 2.Which one of the following assets is generally the m..
$12.00

This Tutorial was purchased 13 times & rated A by student like you.

FIN 571 Week 1 Connect Problems (Week 1 Problem Set) 1.The ultimate control of a corporation lies in the hands of the corporate: president. board of directors. chairman of the board. chief executive officer. stockholders. 1. (Set 2) If a firm is currently prof..
$25.00

This Tutorial was purchased 4 times & rated A+ by student like you.

1.A proxy fight occurs when: the board of directors disagree on the members of the management team. 2. A stakeholder is any person or entity: 3.Which one of the following is least apt to help convince managers to work in the best interest of the stockholders? threat of a proxy fight pa..
$10.00

This Tutorial was purchased 14 times & rated A+ by student like you.

The executive team of New Heritage Doll has completed the decision making for capital budgeting for the firm. Now the team must decide which decisions and approach were the best for the company. The executive team must create a presentation to be given to the board members of New Heritage Doll Comp..
$10.00

This Tutorial was purchased 8 times & rated A+ by student like you.

1.The difference between the present value of an investment’s future cash flows and its initial cost is the: payback period. internal rate of return. profitability index. discounted payback period. net present value. 2.Which statement concerning the net present value (NPV) of an investment ..
$10.00

This Tutorial was purchased 8 times & rated A by student like you.

Acting as the executive team for a small company, your team will apply the principles of capital budgeting to invest in growth and cash flow improvement opportunities in three phases over 10 simulated years. Each opportunity has a unique financial profile and you must analyze the effects on working ..
$10.00

This Tutorial was purchased 13 times & rated A+ by student like you.

Select three publicly traded companies. Choose one each from the following sectors: manufacturing, service, and retail. At least one of the three companies should be foreign. If possible, choose from among the team members' places of business or similar industries. Calculate the following: • Curr..
$10.00

This Tutorial was purchased 2 times & rated A+ by student like you.

The executive team of New Heritage Doll has completed the decision making for capital budgeting for the firm. Now the team must decide which decisions and approach were the best for the company. The executive team must create a presentation to be given to the board members of SNC. Compare the decis..
$10.00

This Tutorial was purchased 2 times & rated A+ by student like you.

Acting as the executive team for a small company, your team will apply the principles of capital budgeting to invest in growth and cash flow improvement opportunities in three phases over 10 simulated years. Each opportunity has a unique financial profile and you must analyze the effects on working ..
$25.00

This Tutorial was purchased 4 times & rated A+ by student like you.

1. Financial managers should primarily strive to: 2. The process of planning and managing a firm's long-term assets is called: 3. Which one of the following actions by a financial manager creates an agency problem? 4. Which one of these is a cash outflow from a corporation? 5. For each of the fo..
$30.00

This Tutorial was purchased 3 times & rated A+ by student like you.

This Tutorial also contains 2 other sets This tutorial contains 3 set of final along with excel file which can be used to solve question in case value changes 1.Which one of the following parties is considered a stakeholder of a firm? 2.The process of planning and managing a firm's long..
$12.00

This Tutorial was purchased 5 times & rated A+ by student like you.

About Your Signature Assignment: This signature assignment is designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree. The sig..
$15.00

This Tutorial was purchased 4 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to demonstrate to students how the issuance of debt to purchase outstanding common stock could affect the value of the company's equity and redefine the capital structure. The problem will also allow students to explore the effect of corporate..
$12.00

This Tutorial was purchased 6 times & rated A by student like you.

The purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods. Assignment Steps Resources: Corporate Finance Create a 350-word memo to management including the following: • Describ..
$9.00

This Tutorial was purchased 1 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to allow the student an opportunity to explain what it means to have an efficient capital market. Students will gain an understanding of the different levels of market efficiency and how behavioral finance can inhibit reaching market transpar..
$12.00

This Tutorial was purchased 3 times & rated A+ by student like you.

Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: • Pharmaceutical • Energy • Retail • Automotive • Computer Hardware • Manufacturing • Mining Access Yahoo Finance and enter the company name. Review the financial information an..
$10.00

This Tutorial was purchased 5 times & rated A+ by student like you.

The purpose of this assignment is to allow the student an opportunity to calculate the rate of return of equity and debt instruments. It allows the student to understand the effects of dividends; capital gains; inflation rates; and how the nominal rate of return affects valuation and pricing. The as..
$10.00

This Tutorial was purchased 3 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following ind..
$10.00

This Tutorial was purchased 4 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to allow the students an opportunity to complete their financial evaluation of a company using the financial research database Plunkett Research Online. Plunkett Research Online provides in-depth analysis of a company's financials, comparisons..
$20.00

This Tutorial was purchased 4 times & rated A by student like you.

Question 1 The underlying assumption of the dividend growth model is that a stock is worth: A. An amount computed as the next annual dividend divided by the required rate of return. B. An amount computed as the next annual dividend divided by the market rate of return. C. The same amount compu..
fin571 © 2017 All Rights Reserved.Powered by:Webzindagi