Page 1 of 62
New Perspectives Excel 2019 | Module 8: SAM Project 1a
Cairo Consulting EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS GETTING STARTED Open the fileNP_EX19_8a_FirstLastNamexlsx, available for download from the SAM website. Files downloaded from the SAM website are safe and do not contain viruses, but due to a recent Microsoft policy update, macros in downloaded files are disabled by default. To complete this project, you will need to enable macros in the file. To enable macros on this file: For PC: Open Windows File Explorer and go to the folder where you saved the file. Right-click the file and choose Properties from the context menu. At the bottom of the General tab, select the Unblock checkbox and select Apply, and then click OK. For Mac: If a dialog box about…
New Perspectives Excel 2019 | Module 7: SAM Project 1a
Valerian State College SUMMARIZING YOUR DATA WITH PIVOTTABLES GETTING STARTED Open the file NP_EX19_7a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_7a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_7a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Lael Masterson works in the Student Activities Office at Valerian State College in…
New Perspectives Excel 2019 | Module 6: SAM Project 1a
Oval Lake Hospital MANAGING YOUR DATA WITH DATA TOOLS GETTING STARTED Open the file NP_EX19_6a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_6a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_6a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Donnie Cruz is a finance assistant for Oval Lake Hospital in south…
New Perspectives Excel 2019 | Modules 1-4: SAM Capstone Project 1a
Tallridge Regional Medical Center Formatting, Formulas, and Charts GETTING STARTED Open the file NP_EX19_CS1-4a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_CS1-4a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_CS1-4a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. Carmelo is building…
New Perspectives Excel 2019 | Module 5: SAM Project 1a
Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS GETTING STARTED Open the file NP_EX19_5a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_5a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer: xlsx docx With the file NP_EX19_5a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file…
The business is a Home Furniture Retailer which buys from suppliers
Using MYOB Accounting program to record the same business transactions and end of month adjusting entries and generate the required reports from MYOB. Business data The business is a Home Furniture Retailer which buys from suppliers and sells to other retail businesses. The business name is “Student Name Furniture Pty Ltd” (students are to insert their name) and is located at Your Address – Sydney NSW 2000. The business’ sales are both over-the-counter cash and credit to wellknown customers. Company Name Address ABN Current Financial Year Starter Chart “Your name” Furniture Pty Ltd Your Address Your student Number 2023 Wholesale Furniture store Financial Year 1st July 2022 – 30th June 2023 Transaction Sources: Cash registers –…
QUT and All Star Manufacturing
Project 1 Calculations must be done in Excel – This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV). QUT corporation projects their future unit sales for a new headphone. The projected unit sales are as below. 1 2 3 4 5 Unit sales 75000 88000 120000 95000 60000 To produce the headphones, the initial net working capital of $2,000,000 is required and additional net working capital is also required each year, which is 20% of the projected sales increase for the following year. The net working capital will be recovered at the end of a project. In addition, the initial installation cost of the machine for…
Emily Dao, 27, just received a promotion
Emily Dao, 27, just received a promotion at work that increased her annual salary to $37,000. She is eligible to participate in her employer’s 401(k) retirement plan in which the employer matches, dollar for dollar, workers’ contributions up to 5 percent of salary. However, Emily wants to buy a new $25,000 car in three years, and she wants to have enough money to make a $7,000 down payment on the car and finance the balance. Fortunately, she expects a sizable bonus this year that she hopes will cover that down payment in three years. A wedding is also in her plans. Emily and her boyfriend, Paul, have set a wedding date two years in the future, after he finishes medical school.…
Morning Star and Aileen Ltd
Question 1 Morning Star Ltd was registered on 1 July 2021, as a company with a constitution limiting the shares that could be offered to 5 000 000 Ordinary shares (including all classes) and 2 000 000 preference shares. The company issued a prospectus dated 1 July 2021 inviting the public to apply for 2 000 000 Ordinary A class shares at $7.00 per share. The terms of the shares on issue are $4.00 on application, $2.00 on allotment and a future call of $1.00 with date to be determined. If the issue is oversubscribed the directors will make a pro-rata issue of shares and the excess application money will be applied to allotment and calls before any refunds will be…
In the new project, the company will buy a new machinery
Your group is working in Finance Department of a production company. Your company is considering a new investment project. In the new project, the company will buy a new machinery that enable to launch a new product. It is expected an annual sale of 20,000 products for an average price of $450 per unit for 5 years. The new investment project has the initial cost of $1,850,000, a residual value of $350,000 at the end of the project. The company will need to add $400 000 in working capital which is expected to be fully retrieved at the end of the project. Other information is available below: Depreciation method: straight line Variable cost per unit: $270 Cash fixed costs per year:…
Big Bang Ltd is considering to invest in one of the two following projects
Question 1 Big Bang Ltd is considering to invest in one of the two following projects to buy a new equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 8%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $186,000 $195,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 86 000 93 000 83 000 75 000 55 000 97 000 84 000 86 000 75 000 63 000 Big Bang’s net income in current year is $450,000. The company maintains a capital structure of 55% in equity funding and…
ABC Ltd has the following land and buildings
Question 1 ABC Ltd has the following land and buildings in its financial statements as at 30 June 2022: Residential land, at cost 2 000 000 Factory land, at valuation 2020 1 800 000 Buildings, at valuation 2020 1 600 000 Accumulated depreciation (200 000) At 30 June 2022, the balance of the revaluation surplus is $800 000, of which $600 000 relates to the factory land and $200 000 to the buildings. On this same date, independent valuations of the land and buildings are obtained. In relation to the above assets, the assessed fair values at 30 June 2022 are: Residential land, previously recorded at cost 2 200 000 Factory land, previously revalued in 2020 1 400…
Page 1 of 62