Financial Accounting Homework Help

Search for question

Questions & Answers

ASSIGNMENT OUTLINE Assignment title: Financing for tourism Weighting: 100% Faculty responsible: John Ryan Programme: PGD Course name: (P5011) Hospitality Finance & Performace Management Hand out date: January 27 2023 Hand-in date to Faculty: February 15 2023 Assignment Overview: Read the case and .answer the questions at the end. Overall aim: To have a complete understanding challenges and strategies to be successful in the current environment. Organisation and methodology: This is a individual assignment and should be presented through Turnitin in Moodle. Please beware Turnitin will automatically detect plagiarism so please do not copy and paste. Resources available: Open book. All the work carried out during the course is expected to be included in the plan. The theory behind the practical initiatives is to be explained to further enhance the credibility of the plan. Questions: Describe the annual seasonality of VCLA income or room demand. View the Financial Statements. Students can review historical profit and loss (P&L) records to develop or describe the seasonality over the year. 2. Why do VCLA’s revenue spikes not always occur at the same time as maximum room demand? Students should understand the difference in timing between when the hotel collects the assessment and when the city actually deposits it in the VCLA’s account. Room demand is an example of a good indicator of when the hotel collects the income. 3. What is the average historical growth rate of VCLA revenue? Review the Forecast. The average historical growth rate is ?. However, growth since the inception of the operation is not sustainable. What should they do? 4. What would the sales growth rate be in an economic decline or upturn? Review Scenarios. Analyse the four scenarios for growth rate and marketing spending adjustment. 5. What financial and economic assumptions must be considered to develop the forecast? Review room supply may impact VCLA revenue and GDP data. Assessment tasks & weighting: 10% of each section is based on the level of English demonstrated within the report. Common skills: assessed (bold) or developed (italics): MANAGING AND DEVELOPING SELF 1.Manages own role and responsibilities 2. Manages own time in achieving objectives. 3.Undertakes personal and career development 4. Transfers skills gained to new and changing situations and contexts. 5.Uses a range of thought processes WORKING WITH AND RELATING TO OTHERS 6.Treats others’ values, beliefs and opinions with respect 7.Relates to and interacts objectively with individuals and groups 8.Works effectively as a member of a team COMMUNICATING 9.Receives and responds to a variety of information 10.Presents information in a variety of visual forms 11.Communicates in writing 12.Participates in oral and non-verbal communication MANAGING TASKS AND SOLVING PROBLEMS 13.Uses information sources 14. Deals with a combination of routine and non-routine tasks 15.Identifies and solves routine and non-routine problems BECOMING NUMERATE AND USING TECHNOLOGY 16.Applies numerical skills and techniques 17.Uses a range of technological equipment and systems Plagiarism: Plagiarism is the act of presenting another’s ideas or words as one’s own. Cheating includes, but is not limited to, the intentional falsification or fabrication of any academic activity, unauthorized copying of another person’s work, or aiding and abetting any such acts. Particular care must be taken when presenting information that has been obtained from an internet site. Should this information not be correctly referenced, then you are guilty of plagiarism and will be penalised accordingly. With respect to projects/assignments, faculty reserves the right to randomly call upon any student and ask them to defend their work orally. Any assignment/exam which is found to contain plagiarism will automatically be awarded a grade of 0, and an e-mail will be sent to the student or the student’s parents/tutors/sponsors. Depending on the circumstances, additional penalties could be imposed (see LRM Academic Regulations, Section 11). Statement of authorship Following the title page of your assignment there should be a page on which you sign a statement that the work included in the assignment is your own work except where appropriately referenced. The following statement should be used: Statement of authorship I certify that this assignment is my own work and contains no material which has been submitted as part of an assignment in any institute, college or university. Moreover, to the best of my knowledge and belief, it contains no material previously published or written by another person, except where due reference is made in the text of the assignment. Signed Name Student number. Abstract This case examines the financial reports for a tourism improvement district and discusses its need to develop a revenue forecast. Assessment revenue is collected by tourism improvement districts and is used to fund destination marketing initiatives. The Ventura County Lodging As- sociation has identified an opportunity to more effectively manage a large cash reserve ac- count and the expected revenue it may collect moving forward. Students are provided with the resources to develop revenue forecast scenarios using tourism district and hotel performance benchmarking data. Case Introduction Video: https://sk.sagepub.com/cases/forecasting-assessment-revenue-ventura-county-lodging-association#i59 After the Great Recession of 2008, the lodging industry and cities in Ventura County, southern California, ex- perienced a loss of economic activity and revenue usually generated through tourist visitation to the area. Ho- tel operators in the cities of Camarillo, Oxnard, and Ventura decided to pool resources to promote awareness of the area and thus increase demand for lodging accommodation. To accomplish this, the Ventura County Lodging Association, or the VCLA, was formed in 2011; the city of Port Hueneme joined in 2015. This four-city area is branded in marketing initiatives and functions as a tourism improvement district through the Ventura County Coast (https://venturacountycoast.com/). Video 1. Introduction to the VCLA The four-city area is in the western coastal part of Ventura County, separated geographically by the Santa Monica Mountains to the east and north. This area has several recreational areas including the Channel Is- lands National Park, beaches, and hiking trails that attract visitors seeking to escape to the outdoors. These cities naturally joined together to promote the region and are adjacent to established tourism districts (Tucker, 2019c) serving the Santa Barbara area to the north and Conejo Valley to the West . Figure 1. VLCA District Map Source: VCLA The VCLA mission is to drive tourism or room night demand through targeted marketing, event development, sales, and public relations (Tucker, 2019b). The advisory board that oversees the association’s activities cur- rently consists of operators of the lodging properties, such as hotel general managers, hotel sales directors, and representatives from city level tourist boards. There are more than 60 lodging properties in the area, which can be classified as hotels, motels, bed and breakfasts, and recreational vehicle (RV) resorts. The as- sociation receives assessment revenue to fund its promotional activities through a 2% assessment collected from the four cities that are part of the VCLA. This assessment is collected proportionally on every room night a guest stays at a lodging accommodation. Once the city has collected the assessment from the lodging prop- erties, the funds are deposited in the VCLA’s bank account. Therefore, the revenue generated by the VCLA is contingent upon hotel demand and the daily rate visitors to the area spend at lodging properties. Since its inception in 2011, the VCLA has been building a cash reserve for emergencies and other short-term needs. As a result of only depositing funds in the account, and never needing to make a withdrawal, the re- serve had grown to over USD 2 million by late 2018. The funds had been held from the start in a simple money market account at a regional bank. At one of the VCLA board meetings, it was decided to investigate options to manage this reserve account more effectively and to address two concerns. The first concern was that the VCLA funds were in a simple ac- count that was not earning optimal interest rates which may be available through other financial institutions or instruments. The second concern involved the Federal Deposit Insurance Corporation (FDIC), which insures coverage only up to USD 250,000 per entity. In other words, if the bank failed, the VCLA would be at risk of being unable to recover USD 1.75 million, since the funds were held at one institution. Hence, the VLCA de- sired a prudent short-term asset account management strategy that offered additional insurance protection, competitive rates of return, and alignment with its financial goals. To determine the best financial instruments to invest the USD 2 million already in the account, as well as the revenue it expected to receive in the coming year, an assessment revenue forecast was required. Assessment Districts An assessment district is an entity “formed to finance improvements when no other source of money is avail- able” and is created “by a sponsoring local government agency, such as a city or county” (California Tax Data, 2020). The Ventura County Coast is an assessment district that provides specific benefits to payers by fund- ing marketing and sales promotion efforts for assessed businesses. The district was created in 2011 as the Ventura–Oxnard–Camarillo Tourism Business Improvement District by Ventura City Council Resolution No. 2011-023 (Hoffman, 2015). As a non-profit and assessment district, the VCLA cannot levy taxes itself but is able to partner with city officials to create the tax required to fund its operations. The assessment rate is 2% of gross short-term (stays less than 31 days) room rental revenue. Based on the benefit received, assessments will not be collected on stays of more than 30 consecutive days. The cities are responsible for collecting the assessment on a monthly basis (including any delinquencies, penalties, and interest) from each lodging business located within their jurisdiction. The cities are expected to take all rea- sonable efforts to collect the assessments from each lodging business. Transient Occupancy Tax Taxes are levied by governments on their citizens at various levels, including federal, state, county, city, and district level. The taxes generate revenue that is used to fund a variety of programs and initiatives, including national defense, education, courts, highways, and other infrastructure projects, workforce development, and, as with this case, bolstering a specific industry such as tourism. Taxes can be levied on specific industries or sectors to further support economic development of an area. Within the hospitality industry, one such tax developed to support city tourism and economic development is a transient occupancy tax or TOT (Tucker, 2019a). Added to the city sales tax, a TOT is a tax levied on guests for each night they stay at a hotel. The revenue from the taxes is then distributed to the entities which proposed the tax to be collected. Depending on the organization and accounting capabilities of the city itself, this revenue is provided to the assessment district in one to three months. In the state of California, local tourism board assessments range from 1–4% of the nightly rate, depending on the specific city (Civitas, 2017). It may also take the form of a flat rate per night ranging from USD 1–4.50. In the City of Camarillo, for example, a hotel guest pays taxes of 13%, or an extra USD 13 on a USD 100 per night rate. This rate is composed of 9% in city TOT taxes, 2% assessment to support the Camarillo Hotel and Tourism Association, and 2% to support the VCLA. While a hotel may record a room sale in a given month, it may not provide its tax receipts to the city until a month later, which in turn provides the VCLA with its assess- ment revenue a further two months later. As occupancy rates and the daily rate increase, so too will the city TOT revenue. With stable public and pri- vate funding for tourism marketing efforts, annual occupancy rates should increase significantly as new mar- keting and sales promotion programs are implemented. Greater occupancy will also produce an increase in TOT and assessment revenues from tourist spending. This represents a substantial return to cities and to tourism improvement districts. Effect of Seasonality in Hotel Demand According to Kenton (2019), “Seasonality is a characteristic of a time series in which the data experiences regular and predictable changes that recur every calendar year”. Hartman (1986) referred to this seasonality related to tourism as the reliable and predictable recurrence of tourists. Seasonality for each destination is dif- ferent, but they are commonly impacted by factors such as weather, public holidays, cultural traditions, leisure or business events in the area, family behavior such as summer vacations, as well as their own local attrac- tions (see Figure 2). Although the number of visitors is a measurement for tourism seasonality, the seasonality of hotel demand can be measured in terms of room nights or, as defined by Smith Travel Research (2020), “as the number of rooms sold in a specified time period.” Smith Travel Research (STR) provides its clients with various reports that detail key hotel performance met- rics such as demand. One type of report that can capture this data for multiple cities is a trend report. This report can provide performance data by month for multiple years, which can be analyzed to chart the season- ality of the destination. Reviewing this type of data for the four-city area can illustrate the seasonality during the year, which naturally peaks during the summer months when the area’s beach attractions are most popu- lar. Figure 2. Seasonality Room Demand Chart Source: Authors, based on VCLA data Forecast Development Any business entity that is accountable to stakeholders or shareholders tries to reduce uncertainty. Business- es plan to be prepared and to anticipate any challenge or opportunity to remain as financially stable as pos- sible within the expected accuracy range (Chien, 2014a). Budgeting and forecasting vary based on the inten- tion and frequency of use. Businesses prepare budgets toward the end of their fiscal year cycle to plan for the following year’s strategies. For most companies, once the budget is finalized before the new fiscal year begins, there is no further change. In contrast, a forecast is not set in stone (Chien, 2014a). The process of budget preparation often involves different types of forecasting. After a business’s strategies are prioritized and set for the following fiscal year, the next step is to forecast revenue (Besley & Brigham, 2018). Revenue forecast determines the resources required for the operations needed to meet the strategies, as shown schematically in Figure 3. Hence, a business often uses three years of a historical revenue less expenses (R−E) statement to determine how to adjust past spending trends to support the new strategies (Sowa, 2017). However, the operation budget cannot be fully in place until the capital expenditure budget (CAPEX) is complete and available (Besley & Brigham, 2018). Therefore, businesses often examine neces- sary investment projects to meet their strategies (Chien, 2014b). The CAPEX involves three types of cash flow forecast: (a) initial outflow of the investment; (b) operational cash flow during the length of the project; and (c) terminal cash flow at the end of the investment project period (Besley & Brigham, 2018). Once the CAPEX cash flow is in place, the finance department evaluates whether the investment project meets specific pre-set criteria. Each business defines criteria based on in- dustry specifics. Examples of criteria measurement tools include payback period, net present value, modified internal rate of return, and economic value add (Matias & Hutchinson, 2016). Figure 3. Forecasting Process Source: Modified by the authors from Besley & Brigham (2018) and Chien (2014a). When the management team approves the investment project(s), the finance department determines the ad- ditional funds needed (AFN) while forecasting the balance sheet statement. Once the AFN are in the balance sheet, the amount of the capital cost circles back to the R−E to finalize the new year’s budget (Besley & Brigham, 2018). However, the process continues throughout the fiscal year to re-forecast when the manage- ment team monitors the budget compared to the actual spending. Re-forecast can occur weekly, monthly, or as frequently as needed in the business (Chien, 2014b). Revenue Forecast Application A revenue forecast is needed to determine the expected income for the VCLA accounts. The development of a revenue forecast and the accuracy of the forecast starts with various assumptions. There are several assumptions that VCLA needed for a five-year revenue forecast. Both macroeconomic and microeconomic indicators of future hotel demand should be evaluated. There are three types of assumptions to consider: (a) industry growth rate benchmark; (b) overall U.S. economic indicators; and (c) internal historical sales trend. Industry Growth Rate Benchmark Two hotel performance benchmarks in the hospitality industry are the reports produced by STR and Coldwell Banker Richard Ellis (CBRE). STR produces various hotel performance reports that allow hoteliers to bench- mark their performance relative to competitors on key performance indicators, and to understand how a mar- ket is performing overall. The CBRE report provides information on real estate market conditions. Both STR and CBRE reports provide local data and historical trends to help establish local industry bench- marks. Analyzing these local industry benchmarks helps lodging properties to set their sales goals. Hence, the first key assumption is the local industry growth rate, which can be used in forecasting VCLA revenue. The STR and CBRE reports can provide occupancy and average daily rates, room demand, and room rev- enue for properties that report their data. Room demand and revenue are particularly valuable in illustrating historical trends. The average local industry growth rate trend is determined by averaging monthly changes in demand and revenue using the last five years of data; that is, by taking the five years of monthly changes in demand and averaging them into one number. The result represents the average growth rate for forecasting purposes. Additionally, the average growth rate can be used to determine how the VCLA is performing rela- tive to the local industry and where it will be in the future—and thus how to account for future projects that VCLA will need to implement to meet any further demand. Overall U.S. Economic Indicators Besides industry growth rates, firms need to consider more broadly the current health of the U.S. economy by using the Federal Reserve interest rate, inflation, unemployment, and wages growth figures. These macro- economic indicators are often used in forecasts in the context of understanding how the U.S. economy may affect demand within the cities of the VCLA. Macroeconomic indicators ultimately affect how much revenue the VLCA will generate in the next few years. Historical Sales Trends The last assumption arises from analysis of the historical R−E. The historical R−E illustrates the trend of growth (or loss) in the sales and net profit margin. In a not-for-profit organization, the net profit is added to the assets in the balance sheet. Net profit margin is net income divided by sales. Unlike for-profit organizations, the net income of not-for-profit organizations is recorded in the assets (or reserve) in the balance sheets, rather than as retained earnings. The historical R−E trend informs us about the average monthly operating expenses needed to support the growth of the sales trend. The average monthly operating expenses also determine the need for how much liquid short-term assets need to be set aside in case of emergency. Short-Term Reserve Accounts Management Strategy The short-term reserve accounts management strategy of the VCLA is shown schematically in Figure 4 and is as follows: Operation account is for daily operations such as fixed or variable expenses. Emergency funds account is liquid and provides necessary cash in case of deficiency of the opera- tion account. Short-term reserve account is a short-term reserve that houses an investment time horizon of less than one year. Long-term reserve account is a long-term reserve that houses an investment time horizon greater than one year. Figure 4. Schematic Illustration of the Short-Term Accounts Management Strategy Source: Developed by the authors Each of the accounts houses 3 months’ worth of average monthly operating expenses. The strategy of four separate accounts was included in the request for proposal (RFP) for local financial institutes to bid for the account management. Five of the 16 bidders were selected to present their plans to the VCLA board. Two firms were selected to implement their short-term reserve account management strategy for VCLA. Table 1 illustrates four accounts and the appropriate insurance. The Securities Investor Protection Corpo- ration (SIPC) protects in the event that a brokerage firm fails. SIPC insurance covers deposits up to USD 500,000 per entity and per financial institution. Some financial institutions offer extended SIPC coverage to their customers. Table 1. Type of Accounts, Related Insurance, and Financial Institutes Accounts Insurance Financial institutes Operation FDIC Current regional bank Emergency FDIC New regional bank Short-term FDIC and SPIC New local fee-based wealth management firm Long-term SPIC Competition and Risk Scenarios The neighboring counties of the VCLA area, such as Santa Barbara and Los Angeles, are also competing for tourism and lodging business, as are all other counties in California. This competition was part of the impetus for the VCLA to form originally, because even though the hotels within the association compete with each other, their goal is to increase aggregate demand such that all members benefit. The 2008 Great Recession was integral in spurring the creation of the VCLA. Economies experience cycles, so it is only a matter of time before the next downturn, which could once again severely impact demand for VCLA member business. When another downturn occurs, the VCLA would likely increase its spending on marketing activities with the hope of increasing, or at least maintaining, market demand. To anticipate competition and macroeconomic risk, it is necessary to develop scenarios for sensitivity testing of the forecasts. To execute multiple scenarios, assumptions for demand growth need to be established to reflect changes or the impact on the R−E. The revenue available to the VCLA for direct marketing activities is contingent on the amount received through assessment collections, which governs how large its budget will be for the year. Should demand sig- nificantly fall, the VCLA would need to use its short-term assets to supplement its funding for annual market- ing projects to help increase demand and drive more revenue. By examining the effects of demand swings, such as a 10% increase or decrease, strategies can be formed for how to address such scenarios. The VCLA occupancy rates are between 75% and 80%, so if they drop into the percentage range of low 70s to high 60s, they would likely begin to start withdrawing from their reserves to try to increase demand. If they were to increase demand so occupancy rates were in the 80%+ range they would view this as a very healthy signal and would focus on identifying what marketing strategies helped lead to that success. Since the four short-term assets accounts have been identified, it is necessary to forecast three years of ex- pected revenue so that it can be defined how these are funded. Additionally, baseline, worst, and best-case scenarios are required to reduce uncertainty and determine allocation to the short-term assets accounts. Further Reading Association for Financial Professionals. (2014, June). AFP financial planning and analysis learning system ( 2nd ed.). Association for Financial Professionals. Davidson, W. N. (2017). Financial forecasting and decision making. American Institute of Certified Public Ac- countants. Sacks, A. , & Ryan, A. (2017). Lodging tax burden assessment. Oxford Economics. Samonas, M. (2015). Financial forecasting, analysis, and modelling: A framework for long-term forecasting (Wiley finance series). John Wiley & Sons. Smith Travel Research. (2019). Trend report: Ventura, CA area selected properties. Hendersonville, TN. Visit California. (2019). California travel and tourism: Overview of key drivers and outlook. Tourism Econom- ics. https://industry.visitcalifornia.com/research/report/california-travel-tourism-forecast-state-2019-october References Besley, S. , & Brigham, E. (2018). CFIN (6th ed.). South-Western. California Tax Data. (2020). California property tax information. https://www.californiataxdata.com/pdf/Assess- mentDistrict.pdf Chien, C.-L. (2014a, August 24). Budgeting vs. forecasting: What’s the difference? https://vgi168.com/2014/ 08/28/budgeting-vs-forecasting-whats-the-difference/ Chien, Chia-Li . (2014b, August 24). Meet your business goals with forecasting: Creating a forecasting sys- tem. https://vgi168.com/2014/08/28/meet-your-business-goals-with-forecasting-creating-a-forecasting-sys- tem/ Civitas. (2017). Global tourism improvement district tax assessments. http://www.civitasadvisors.com/global- tid-matrix-10-14-2019/ Hartman, R. (1986). Tourism, seasonality and social change. Leisure Studies, 5(1), 25–33. Hoffman, G. (2015). Ventura County West Tourism Business Improvement District. http://oxnard.grani- cus.com/MetaViewer.php?view_id=46&clip_id=3063&meta_id=150269 Kenton, W. (2019). Seasonality. Investopedia: economics. https://www.investopedia.com/terms/s/seasonali- ty.asp Matias, D. B. , & Hutchinson, M. (2016, October). AMA’s advanced financial forecasting and modeling. Amer- ican Management Association. Smith Travel Research (2020). Glossary. https://str.com/data-insights/resources/glossary/d Sowa, L. (2017, September). Financial forecasting. American Management Association. Tucker, B. (2019a). 2018/2019 VCC annual report video. Ventura County Coast. https://www.youtube.com/ watch?v=fcAF2vtWa-4&feature=youtu.be Tucker, B. (2019b). 2019/2020 marketing plan. Ventura County Coast. https://venturacountycoast.com/ventu- ra-county-coast-tourism-impact-summit-resources/ Tucker, B. (2019c). Marketing plan. Ventura County Coast. https://venturacountycoast.com/wp-content/up- loads/2019/09/VCLA_MarketingPlan_8.5X11_092319_WEB.pdf https://dx.doi.org/10.4135/9781529758184


M 9115 Advanced Finance and Budgeting Budgets ASSIGNMENT OUTLINE Assignment title: Analysing a company’s performance Weighting: 30% Faculty responsible: John Ryan Programme: Masters Executive Digital Course name: M 9115 Advanced Finance and Budgeting Hand-in date for Turnitin: N/A Assignment Overview: Individual project: Choose a company and using vertical analysis review their efficiencies when compared to another company within the same industry. Using horizontal analysis, explain how the company is progressing year on year over a three year period and compare the two companys performances. Explain the differences between the two companies, highlighting who you feel is doing the better job. Learning outcomes: Implement advanced planning and control techniques in the budgeting process. Manage the budgeting process. Apply cost estimation techniques. Forecast revenues and expenses under uncertainty. Organisation and methodology: This is a written document, carried out individually. Resources available: Open book. Use all the resources necessary to understand how to create and manage a budget. RUBRIC: 10-8.5 8.49-8 7.9-7 6.9-6 5.9-1 I. Choose a company and using vertical analysis review their efficiencies when compared to another company within the same industry. The information, imported from a credible source, i.e. verified accounts from company annual reports or financial websites e.g. marketwach, every number is analysed for both companie and the comparison covers financial efficieny and liquidity reflecting on the differences between the two companies. External reading and reference is required, The information, imported from a credible source, i.e. verified accounts from company annual reports or financial websites e.g. marketwach, most numbers are analysed for both companie and the comparison covers financial efficieny and liquidity reflecting on the differences between the two companies. External reading and reference is required, The information, imported from a credible source, i.e. verified accounts from company annual reports or financial websites e.g. marketwach, a good analysis for the comparison covers financial efficieny and liquidity reflecting on the differences between the two companies. External reading and reference is required, The information, imported from a credible source, i.e. verified accounts from company annual reports or financial websites e.g. marketwach, a comparison is made between the companies reflecting on the differences between the two companies. External reading and reference is required, If the numbers are not credible, the comparison is not complete or not providing adequate detail. II. Using horizontal analysis, explain how the company is progressing year on year over a three year period and compare the two companys performances. Using the same information compare the perfromance for the companies over a three year period to see how they do in comparison to eachother. Use market information to help identify the exact cause of changes in that time, between the two companies. Using the same information compare the perfromance for the companies over a three year period to see how they do in comparison to eachother. Use market information to help identify the possible reasons of changes in that time, between the two companies. Using most of the information compare the perfromance for the companies over a three year period to see how they do in comparison to eachother. Use market information to help identify the possible reasons of changes in that time, between the two companies. Using most of the information compare the perfromance for the companies up to a three year period to see how they do in comparison to eachother. Use market information to help identify the possible reasons of changes in that time, between the two companies. Failure to make adequate comparisons and / or to justify the findings with real market information. III. Using variance analysis to justify the differences between the initial and optimistic budget. Using at least 5 variance analyses, for both companies, explain how you can more clearly elaborate on the findings from point 2, above. Using at least 4 variance analyses, for both companies, explain how you can more clearly elaborate on the findings from point 2, above. Using at least 3 variance analyses, for both companies, explain how you can more clearly elaborate on the findings from point 2, above. Using at least 2 variance analyses, for both companies, explain how you can more clearly elaborate on the findings from point 2, above. Failure to use or adequate explain variances and linking them to the findings of the previous step. 10% of each section is based on the level of English demonstrated within the report. Common skills: assessed (bold) or developed (italics): MANAGING AND DEVELOPING SELF 1.Manages own role and responsibilities 2. Manages own time in achieving objectives. 3.Undertakes personal and career development 4. Transfers skills gained to new and changing situations and contexts. 5.Uses a range of thought processes WORKING WITH AND RELATING TO OTHERS 6.Treats others’ values, beliefs and opinions with respect 7.Relates to and interacts objectively with individuals and groups 8.Works effectively as a member of a team COMMUNICATING 9.Receives and responds to a variety of information 10.Presents information in a variety of visual forms 11.Communicates in writing 12.Participates in oral and non-verbal communication MANAGING TASKS AND SOLVING PROBLEMS 13.Uses information sources 14. Deals with a combination of routine and non-routine tasks 15.Identifies and solves routine and non-routine problems BECOMING NUMERATE AND USING TECHNOLOGY 16.Applies numerical skills and techniques 17.Uses a range of technological equipment and systems Plagiarism: Plagiarism is the act of presenting another’s ideas or words as one’s own. Cheating includes, but is not limited to, the intentional falsification or fabrication of any academic activity, unauthorized copying of another person’s work, or aiding and abetting any such acts. Particular care must be taken when presenting information that has been obtained from an internet site. Should this information not be correctly referenced, then you are guilty of plagiarism and will be penalised accordingly. With respect to projects/assignments, faculty reserves the right to randomly call upon any student and ask them to defend their work orally. Any assignment/exam which is found to contain plagiarism will automatically be awarded a grade of 0, and an e-mail will be sent to the student or the student’s parents/tutors/sponsors. Depending on the circumstances, additional penalties could be imposed (see LRM Academic Regulations, Section 11). Statement of authorship Following the title page of your assignment there should be a page on which you sign a statement that the work included in the assignment is your own work except where appropriately referenced. The following statement should be used: Statement of authorship I certify that this assignment is my own work and contains no material which has been submitted as part of an assignment in any institute, college or university. Moreover, to the best of my knowledge and belief, it contains no material previously published or written by another person, except where due reference is made in the text of the assignment. Signed Name Student number. Page 4 of 4


Higher National Graded Unit Specification General Information for Centres This Graded Unit has been validated as part of the HNC/HND Mechanical Engineering. Centres are required to develop the assessment instrument in accordance with this validated specification. Centres wishing to use another type of Graded Unit or assessment instrument are required to submit proposals detailing the justification for change for validation. Graded Unit Title: Mechanical Engineering: Graded Unit 2 Graded Unit Code: DV12 35 Type of Graded Unit: Project Assessment Instrument: Practical Assignment Credit points and level: 2 HN Credits at SCQF level 8: (16 SCQF credit points at SCQF level 8*) *SCOF credit points are used to allocate credit to qualifications in the Scottish Credit and Qualifications Framework (SCQF). Each qualification in the Framework is allocated a number of SCQF credit points at an SCQF level. There are 12 SCQF levels, ranging from National 1 to Doctorates. Purpose: This Graded Unit is designed to provide evidence that the candidate has achieved the following principal aims of the HNC/HND awards in Mechanical Engineering: develop the candidate's ability to apply analysis and synthesis skills to the solution of mechanical engineering problems develop the candidate's learning and transferable skills (including Core Skills) develop the candidate's knowledge and skills in planning, scheduling and project management develop the candidate's investigation skills develop a range of Communication knowledge and skills relevant to the needs of mechanical incorporated engineers develop knowledge, understanding and skills in a range of core principles and technologies by undertaking Units in engineering drawing, quality systems, engineering principles, materials selection , statics and strength of materials, dynamics, thermofluids and pneumatics and hydraulics expand on the range of knowledge, understanding and skills in the core HNC Mechanical Principles and Technology section by undertaking Units in Information Technology Applications Software, Engineering Skills, Plant Systems, Heat Transfer and Fluid Mechanics, Applied Industrial Plant Maintenance, Strength of Materials Advanced and Mathematics allow for further specialisation within the following subject areas: CNC, CAD, Design for Manufacture, Control Systems, Mathematics, Single Phase AC Circuits, Analogue and Digital Electronics, PLC, Industrial Systems, Process and Equipment Selection, Metal and Plastic Component Manufacture, Robotics, Project Management and HVAC Design and Practice. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 1 General Information for Centres (cont) Recommended Prior Knowledge and Skills: It is recommended that the candidate should have completed or be in the process of completing the following Units relating to the above specific aims prior to undertaking this Graded Unit: · Communication: Practical Skills Information Technology: Applications Software 1 · Business Awareness and Continuing Professional Development Engineering Drawing Quality Management: An Introduction Engineering Principles Mathematics for Engineering 1: Mechanical and Manufacturing Mathematics for Engineering 2 Materials Selection Statics and Strength of Materials Dynamics Thermofluids Pneumatics and Hydraulics Engineering Skills Plant Systems Heat Transfer and Fluid Mechanics Strength of Materials: Advanced Applied Industrial Plant Maintenance The nature of the project activity detailed in this Specification is such that it is likely that centres will wish their candidates to embark on it from the start of the second year of the HND Mechanical Engineering programme. As it is anticipated that centres will deliver the HNC Mechanical Engineering as part of the first year of the HND, it is recommended that candidates have completed all HNC Mechanical Engineering Units before commencing this project. In principle, the project can draw on any Units in the HND Mechanical Engineering Framework although the majority of the Units should be at SCQF level 8. The project can be taken from one Mechanical Engineering area (eg Plant Systems) or it can span more than one technical area. However, its principal purpose is not to integrate technical content (this is covered in Mechanical Engineering: Graded Unit 1) but rather to combine such knowledge and skills as planning, scheduling, construction, testing, evaluating and reporting. Core Skills: The achievement of this Unit gives automatic certification of the following: Problem Solving at SCQF level 6 Assessment: This Graded Unit will be assessed by the use of a practical assignment (Mechanical Engineering Project). HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 2 . . . . ... General Information for Centres (cont) In developing this specification it was decided that candidates must do a clearly identifiable individual project. However, this does not preclude individual projects being part of a larger group project. Candidates' contribution to a larger group project has the advantage of creating opportunities for the development of the Core Skill, Working with Others. The "fleshed-out" practical assignment should provide the candidate with the opportunity to produce evidence that demonstrates she/he has met the aims of the graded unit that it covers. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 3 Administrative Information Graded Unit Code: DV12 35 Graded Unit Title: Mechanical Engineering: Graded Unit 2 Original date of publication: August 2006 Version: 03 (August 2018) History of Changes: Description of change Date Version 02 Amendment to Core Skills statement on Page 2. Document amended to comply with Disability Discrimination Act. 31/08/06 03 Update of Conditions of Assessment 02/08/18 Source: SQA Scottish Qualifications Authority 2006, 2018 This publication may be reproduced in whole or in part for educational purposes provided that no profit is derived from reproduction and that, if reproduced in part, the source is acknowledged. FURTHER INFORMATION: Call SQA's Customer Contact Centre on 44 (0) 141 500 5030 or 0345 279 1000. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 4 Higher National Graded Unit Specification: Instructions for designing the assessment task and assessing candidates Graded Unit Title: Mechanical Engineering: Graded Unit 2 Conditions of Assessment The candidate should be given a date for completion of the Mechanical Engineering Project. However, the instructions for the assessment task should be distributed to allow the candidate sufficient time to assimilate the details and carry out the assessment task. During the time between the distribution of the assessment task instructions and the completion date, assessors may answer questions, provide clarification, guidance and reasonable assistance. Reasonable assistance is the term used by SQA to describe the difference between providing candidates with some direction to generate the required evidence for assessment and providing too much support, which would compromise the integrity of the assessment. Reasonable assistance is part of all learning and teaching processes. In relation to the assessment of Higher National Project-based Graded Units, assessors may provide advice, clarification, and guidance during the time between the distribution of the project instructions and the completion date, ie at each stage of the project. At this level, candidates should work independently. It is up to centres to take reasonable steps to ensure that the project is the work of the candidate. For example, centres may wish to informally question candidates at various stages on their knowledge and understanding of the project on which they have embarked. Centres should ensure that where research etc. is carried out in other establishments or under the supervision of others that the candidate does not receive undue assistance. Remediation allows an assessor to clarify candidate responses, either by requiring a written amendment or by oral questioning, where there is a minor shortfall or omission in evidence requirements. In either case, such instances must be formally noted by the assessor, either in writing or by recording, and be made available to the internal and external verifier. In relation to Higher National Project-based Graded Units, candidates must be given the opportunity for remediation at each stage of the project. The evidence for a Higher National Project-based Graded Unit is generated over time and involves three distinct stages, each of which has to be achieved before the next is undertaken. This means that any re-assessment of stages must be undertaken before proceeding to the next stage. The overall grade is derived from the total number of marks across all sections, and should reflect the ability of the candidate to work autonomously and the amount of support required. In relation to Higher National Project-based Graded Units, candidates who have failed any stage of the project and have been unable to provide the necessary evidence through remediation must be given the opportunity for re-assessment of that stage. Any candidate who has failed their graded unit or wishes to upgrade their award must be given a re-assessment opportunity, or in exceptional circumstances, two re-assessment opportunities. In the case of project-based graded units, this must be done using a substantially different project. The final grading given must reflect the quality of the candidate's evidence at the time of the completion of the graded unit. Candidates must be awarded the highest grade achieved - whether through first submission or through any re-assessment, remediation, and/or reasonable assistance provided. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 5 Higher National Graded Unit Specification: Instructions for designing the assessment task and assessing candidates (cont) Instructions for designing the assessment task The assessment task is a project. The project undertaken by the candidate must be a complex task which involves: · variables which are complex or unfamiliar relationships which need to be clarified a context which may be familiar or unfamiliar to the candidate The project may consist of one of the following: mechanical hardware only hardware and software * a mechanical design (which may include the use of software) feasibility investigation of a technical issue leading to a report with a clear set of recommendations Examples of such projects include the following: · installation of mechanical equipment (eg compressor, pump etc.) + programming PLC and interfacing PLC to pick and place or other mechanical handling equipment · design of some form of structure (eg. crane, lift etc.) investigation into the procurement and installation of plant for a manufacturing line The assessment task requires the candidate to: · produce a project brief and specification · produce project objectives which define the long term project objectives · draw up an initial project schedule which should be used to inform on-going project planning and development · justify chosen project solution in relation to one or more alternative solutions · develop a verification strategy for the project feed back to project supervisor on a regular basis · access components, software, materials or materials for an investigation implement project solution test product or check investigation data to confirm validity of this data · analyse test results or investigation data · maintain a log book throughout the duration of the project produce a project report which conforms to appropriate reporting standards, includes an evaluation of the project strategy and what the candidate has learnt from undertaking the project present details of the project including a reflective account of the project Outcomes HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 6 Higher National Graded Unit Specification: Instructions for designing the assessment task and assessing candidates (cont) Guidance on grading candidates Candidates who meet the minimum Evidence Requirements will have their achievement graded as C - competent, or A - highly competent or B somewhere between A and C. The grade related criteria to be used to judge candidate performance for this Graded Unit is specified in the following table. It should be noted that in the following table the term 'product' could mean one of the following: · mechanical hardware only hardware and software a mechanical design (which may include the use of software) feasibility study of a technical issue leading to a report with a clear set of recommendations Whichever category is chosen, the project must relate to a practical situation demonstrating how mechanical engineering is utilised in the service of society. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 7 Higher National Graded Unit specification: Instructions for designing the assessment task and assessing candidates (cont) Grade A Is a seamless, coherent piece of work which: · The project brief includes all relevant information, is clear and concise and has been agreed fully with the customer. Grade C Is a co-ordinated piece of work which: · The project brief includes complex, multi-variable information about the main technical requirements of the project and provides a cost indication and expected timescales. The project specification is well structured, contains relevant, accurate information and any revisions made have been agreed with the customer. · The project specification provides clear details of the following: the title of the project; the objectives of the specification; the project's main technical requirements including multi- variables and an acknowledgement of any references or standards relevant to the specification. · The project objectives accurately and fully reflect the long-term project targets. * The project objectives identify the key long-term project targets and multi- variables. · The initial project schedule (probably in the form of a Gantt chart) contains a comprehensive list of project activities and timings. The information in the initial schedule is used to assess if the project can be completed within timescales. The schedule is monitored on a regular basis to inform on-going project planning and development. · The initial project schedule (probably in the form of a Gantt chart) shows all essential project activities and timings. Evidence that the schedule has been monitored on at least three separate occasions during the life of the project to inform on-going project planning and development should be available. · The candidate develops a substantial knowledge base to support the demands of the project. The candidate develops a sound knowledge base to support the demands of the project. · The selected solution is justified in terms of a thorough evaluation of a range of options. The selected solution is justified in terms of a sound evaluation involving the solution and at least one viable alternative option. · A comprehensive verification strategy is developed to ensure the product is completely tested or the investigation findings are fully validated. · A verification strategy is developed to test the essential parts of the product or to validate the principal investigation findings. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 8 Higher National Graded Unit specification: Instructions for designing the assessment task and assessing candidates (cont) Grade A Grade C · The candidate feeds back to her/his supervisor on a regular basis, updating the supervisor on progress made and actions for the next stage of the project · The candidate feeds back to her/his supervisor on at least three occasions providing an indication of progress made · The candidate accesses component and/or software and/ or materials to support an investigation of the correct specification from a range of sources at the most economic price The candidate accesses components and/or software and/ or materials to support an investigation of the correct specification from a range of sources The product is constructed to a high standard and functions correctly or the investigation is carried out in a comprehensive manner The product is constructed to an acceptable standard of quality or the investigation is carried out in a sufficiently detailed manner All tests on the product are conducted in a technically correct way with due account being taken of inaccuracies introduced by the measurement processes or comprehensive checks are made on investigation data to ensure full confidence in the reliability and accuracy data. Tests are carried out in a technically proficient way or sufficient checks are made on the investigation data to ensure reasonable confidence in the reliability and accuracy of the data. The interpretation of test results or investigation data is accurate and the analysis of the results or data is used to identify improvements in product performance or the Outcomes of the investigation. The interpretation of test results or investigation data is correct. The log book is regularly maintained and provides a detailed, informal record of the candidate's thinking as the project develops including reflective comments, The log book contains a complex level of detail about project ideas and progress and there is evidence that entries have been made on at least six occasions during the life of the project, The project report is well-structured, contains only relevant information, has clear and accurate conclusions and recommendations and is in clear and correct English, · The project report meets acceptable standards in terms of structure, use of English and clarity, and has accurate conclusions and recommendations. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 9 Higher National Graded Unit specification: Instructions for designing the assessment task and assessing candidates (cont) Grade A · The project report includes a complex and comprehensive evaluation of the project strategy and activities and includes clear evaluation of what the candidate has learnt from undertaking the project and the factors involved. Grade C The project includes an evaluation of the project strategy and activities and includes an evaluation of what the candidate has learnt from undertaking the project. The presentation is well structured, contains only relevant information, is to time and includes the use of appropriate aids. The presentation is acceptably structured, contains largely relevant information and is to time. · The candidate gives clear, concise and technically accurate answers to questions raised during the presentation. The candidate gives technically correct answers to questions raised as part of the presentation. The candidate includes a complex, reflective account of the success, or otherwise, of project activities against project objectives in the presentation. The candidate includes a reflective account of the success, or otherwise, of the project in the presentation. · The candidate undertakes the project with the minimum of supervision. The candidate undertakes the project without unnecessary interventions from the project supervisor to ensure the project remains on track. The candidate identifies clear and full details of the new knowledge and skills she/he has developed as a result of doing the project such as project management skills, investigation/research skills, keeping to deadlines, recognising limitations of knowledge - approaching expert sources. The candidate provides at least three examples of new knowledge and skills she/he has developed as a result of doing the project. · The candidate introduces a significant novel feature into the project. None · The candidate demonstrates a high level of self-motivation throughout the project. · The candidate demonstrates an acceptable level of motivation throughout the project. · The candidate undertakes additional research well beyond that demanded by the project. None HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 10 Higher National Graded Unit specification: Instructions for designing the assessment task and assessing candidates (cont) The project will be marked out of 100. Assessors will mark each stage of the project, taking into account the criteria outlined. The marks will then be aggregated to arrive at an overall mark for the project. Assessors will then assign an overall grade to the candidate for this Graded Unit based on the following grade boundaries. A = 70% - 100% B = 60% - 69% C = 50% - 59% Note: the candidate must achieve all of the minimum evidence specified below for each stage of the project in order to achieve the Graded Unit. Important Note: Centres must complete the following Grading Checklist for each Mechanical Engineering Project. Completed checklists will be used as part of the external verification process to ensure the accuracy and consistency of grading between candidates in a centre and across centres Notes on completion of the Grading Checklist are shown on page 18. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 11 Scottish Qualifications Authority Mechanical Engineering: Graded Unit 2 (Project) Grading Unit Checklist Centre Name: Centre Number: HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 12 Grading Checklist No. No Grade Grade C 1 Yes Grade C Criteria The project brief includes complex, multi-variable information about the main technical requirements of the project and provides a cost indication and expected timescale. The project specification provides clear details of the following: the title of the project; the objectives of the specification; the project's main technical requirements including multi-variables and an acknowledgement of any references or standards relevant to the specification. Yes Yes Yes The project specification is well structured, contains relevant, accurate information and any revisions have been agreed with the customer. 3 Yes The project objectives identify the key long-term project targets and multi-variables. Yes Grade B Yes Grade A Grade A Criteria The project brief includes all relevant information, is clear and concise and has been agreed fully with the customer. 2 Yes Yes Yes Yes Yes The project objectives accurately and fully reflect the long-term project targets. The initial project schedule (probably in the form of a Gantt chart) contains a comprehensive list of project activities and timings. The information in the initial schedule in used to assess if the project can be completed within the timescales. The schedule is monitored on a regular basis to inform on-going project planning and development. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 13 4 Yes The initial project schedule (probably in the form of a Gantt chart) shows all essential project activities and timings. Evidence that the schedule has been monitored on at least three separate occasions during the life of the project to inform on-going project planning and development should be available. Yes Yes Yes Grading Checklist (cont) No. No Grade Grade C Criteria Grade C Grade B Grade A Grade A Criteria 5 Yes The candidate develops a sound knowledge base to support the demands of the project. Yes Yes Yes The candidate develops a substantial knowledge base to support the demands of the project. 6 Yes The selected solution is justified in terms of a sound evaluation involving the solution and at least one viable alternative option. Yes Yes Yes The selected solution is justified in terms of a thorough evaluation of a range of options. 7 Yes A verification strategy is developed to test the essential parts of the product or to validate the principal investigation findings. Yes Yes Yes A comprehensive verification strategy is developed to ensure the product is completely tested or the investigation findings are fully validated. Yes The candidate feeds back to her/his supervisor on a regular basis, updating the supervisor on progress made and actions for the next stage of the project. 9 Yes The candidate accesses components and/or software and/or materials to support an investigation of the correct specification from a range of sources. Yes Yes Yes The candidate accesses component and/or, software and/ or materials to support an investigation of the correct specification from a range of sources at the most economic price. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 14 8 Yes The candidate feeds back to her/his supervisor on at least three occasions providing an indication of progress made. Yes Yes Grading Checklist (cont) No. No Grade Grade C Criteria Grade C Grade B Grade A Grade A Criteria 10 Yes The product is constructed to an acceptable standard of quality or the investigation is carried out in a sufficiently detailed manner. Yes Yes Yes The product is constructed to a high standard and functions correctly or the investigation is carried out in a comprehensive manner. 11 Yes Tests are carried out in a technically proficient way or sufficient checks are made on the investigation data to ensure reasonable confidence in the reliability and accuracy of the data. Yes Yes Yes All tests on the product are conducted in a technically correct way with due account being taken of inaccuracies introduced by the measurement processes or comprehensive checks are made on investigation data to ensure full confidence in the reliability and accuracy data. 12 Yes The interpretation of test results or investigation data is correct. Yes Yes Yes The interpretation of test results or investigation data is accurate and the analysis of the results or data is used to identify improvements in product performance or the Outcomes of the investigation. 13 Yes The logbook contains a complex level of detail about project ideas and progress and there is evidence that entries have been made on at least six occasions during the life of the project. Yes Yes Yes The logbook is regularly maintained and provides a detailed, informal record of the candidate's thinking as the project develops including reflective comments. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 15 Grading Checklist (cont) No. No Grade Grade C Criteria Grade C Grade B Grade A Grade A Criteria 14 Yes The project report meets acceptable standards in terms of structure, use of English and clarity, and has accurate conclusions and recommendations. Double Weight Yes Yes Yes The project report is well structured, contains only relevant information, has clear and accurate conclusions and recommendations and is in clear and concise English. Double Weight The project report includes a complex and comprehensive evaluation of the project strategy and activities and includes a clear evaluation of what the candidate has learnt from undertaking the project and the factors involved. 16 Yes The presentation is acceptably structured, contains largely relevant information and is to time. Yes Yes Yes 15 Yes The project includes an evaluation of the project strategy and activities and includes an evaluation of what the candidate has learned from undertaking the project. Yes Yes Yes The presentation is well structured, contains only relevant information, is to time and includes the use of appropriate aids. Double Weight The candidate gives clear, concise and technically accurate answers to questions raised during the presentation. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 16 Double Weight 17 Yes The candidate gives technically correct answers to questions raised as part of the presentation. Yes Yes Yes Grading Checklist (cont) No. No Grade Grade C Criteria Grade C Grade B Grade A Grade A Criteria 18 Yes The candidate includes a reflective account of the success, or otherwise, of the project in the presentation. Yes Yes Yes The candidate includes a complex, reflective account of the success, or otherwise, of project activities against project objectives in the presentation. 19 Yes The candidate undertakes the project without unnecessary interventions from the project supervisor to ensure the project remains on track. Yes Yes Yes The candidate undertakes the project with the minimum of supervision. 20 Yes The candidate provides at least three examples of new knowledge and skills she/he has developed as a result of completing the project. Yes Yes Yes The candidate identifies clear and full details of the new knowledge and skills she/he has developed as a result of doing the project such as project management skills, investigation/research skills, keeping to deadlines, recognising limitations of knowledge - approaching expert sources. 21 Yes None Yes Yes Yes The candidate introduces a significant novel feature into the project. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 17 Grading Checklist (cont) No. 22 No Grade Grade C Criteria Grade C Grade B Grade A Grade A Criteria Yes The candidate demonstrates an acceptable level of motivation throughout the project. Yes Yes Yes The candidate demonstrates a high-level of self-motivation throughout the project. 23 Yes None Yes Yes Yes The candidate undertakes additional research well beyond that demanded by the project. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 18 Guidance on the Completion of the Grading Checklist Centre staff are asked to read the following guidance notes before completing the Grading Checklist. The checklist had been designed to help assessor(s) decide what Grade should be awarded to a candidate completing the Mechanical Engineering Project. It will also be used by external moderators as part of the external verification of project work. A Grading Checklist form should be completed for each candidate who has been entered for the Mechanical Engineering: Graded Unit 2 (Mechanical Engineering Project) In completing the checklist, assessors should take note of the following points. 1 For each item shown in the checklist, the Yes should be circled which most closely reflects the candidate's performance. It can be seen from the checklist that grade criteria for Grade C and Grade A passes have been included in the checklist and items 14 and 16 are double weighted. 2 A Grade B should be awarded where a candidate's performance lies approximately mid-way between a Grade C and a Grade A (ie better than a Grade C (Competent) but not good enough to be a Grade A (Highly Competent). 3 No grade should be awarded where a candidate's performance is not good enough to satisfy a Grade C Pass (ie a competent level of performance). 4 Once centre assessor(s) have completed the 23 items, they should then apply their own professional judgement to decide what Grade to award the candidate. 5 In arriving at the grade, due account should be taken of the distribution circles around 'Yes'. For example, if 19 out of the 24 items have been circled 'Yes' under the Grade B column and the other 5 have been circled under the Grade C column, then it is likely that the assessor(s) will award the candidate a Grade B. Professional judgement is much more involved where, for example, if 'Yes' is circled 12 times under the Grade A column and 12 times under the Grade B column. The assessor's first-hand knowledge of the candidate's performance will influence whether the candidate is awarded Grade A or Grade B. External moderators are unlikely to overturn the grading awarded by the Centre assessor(s) unless they are not happy that grading judgements have been awarded in a fair, consistent and rigorous manner. Centres may provide additional comments and/or evidence in support of their grading decisions. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 19 Higher National Graded Unit specification: Instructions for designing the assessment task and assessing candidates (cont) Evidence Requirements The project consists of three stages: planning; developing; and evaluating. The following table specifies the minimum evidence required to pass each stage. Note: The candidate must achieve all of the minimum evidence specified below for each stage of the project in order to pass the Graded Unit. Project Stage Minimum Evidence Requirements Stage 1 - Planning · A project brief identifying customer requirements A project specification that the customer has agreed · A set of project objectives A project schedule Information about the different solutions Justification of the chosen solution Verification strategy Maintenance of a log book Complies with Health and Safety procedures The candidate must achieve all of the minimum evidence specified above in order to pass the Planning stage. Stage 2 - Developing Practical output from the project (design, analysis, installation, investigation etc.) . Records of progress underpinning the project such as: Log book — — Progress reports — Test results or investigation findings as part of the verification strategy Complies with Health and Safety procedures The candidate must achieve all of the minimum evidence specified above in order to pass the Developing stage. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 20 Higher National Graded Unit specification: Instructions for designing the assessment task and assessing candidates (cont) Project Stage Minimum Evidence Requirements Stage 3 - Evaluating Review of project specification as the project progresses · Review of project schedule as the project progresses · Analysis used to decide project option Progress reporting and goal setting as part of project implementation Actions taken to overcome unforeseen circumstances Interpretation of test results or investigation findings · Action taken as a result of test results or investigation findings interpretation An assessment of the strengths and weaknesses of the practical output of the project An evaluation of the extent to which the project brief and objectives have been overtaken · Reflective part of presentation Indication of any knowledge and skills which have been gained by the candidate Complies with Health and Safety procedures The candidate must achieve all of the minimum evidence specified above in order to pass the Evaluating stage. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 21 Higher National Graded Unit specification: Instructions for designing the assessment task and assessing candidates (cont) Equality and inclusion This graded unit specification has been designed to ensure that there are no unnecessary barriers to learning or assessment. The individual needs of learners should be taken into account when planning learning experiences, selecting assessment methods or considering alternative evidence. Further advice can be found on our website www.sqa.org.uk/assessmentarrangements. HN Graded Unit (DV12 35): Mechanical Engineering: Graded Unit 2 22


M 9115 Advanced Finance and Budgeting Budgets ASSIGNMENT OUTLINE Assignment title: Budgets Weighting: 20% Faculty responsible: John Ryan Programme: Masters Executive Digital Course name: M 9115 Advanced Finance and Budgeting Hand-in date for Turnitin: N/A Assignment Overview: Individual project: You will use the budgeting example given in the assessment area. Using that budget as an EXAMPLE ONLY, you will need to adjust your figures, revenue streams and costs to reflect the business you described in your entrepreneurship course. You will then explain your assumptions while highlighting our understanding of the concepts used in budgeting and variances. Questions: Give a brief synopsis of your business plan and use the budget template to project future performance, explaining why you feel the company will achieve that performance. Create an optimistic projection and use variance analysis to explain how those changes may arise. Learning outcomes: Implement advanced planning and control techniques in the budgeting process. Manage the budgeting process. Apply cost estimation techniques. Forecast revenues and expenses under uncertainty. Organisation and methodology: This is a written document, carried out individually. Resources available: Open book. Use all the resources necessary to understand how to create and manage a budget. RUBRIC: 10-8.5 8.49-8 7.9-7 6.9-6 5.9-1 1. Creation of the budget Clearly and explicitly defines the revenues and costs both individually and as part of the business plan, demonstrating a logical and reasonable approach to projections. Every number should be explained referring to the market expectations you analyzed in your entrepreneurship course. Clearly and explicitly defines the revenues and costs both individually and as part of the business plan, demonstrating a logical and reasonable approach to projections. The concept is adequately explained, referring to the market expectations you analyzed in your entrepreneurship course. Defines the revenues and costs as part of the business plan, demonstrating a logical and reasonable approach to projections. The numbers should be adequately explained to the market expectations you analyzed in your entrepreneurship course. The revenues and costs are adequately explained as part of the business plan, demonstrating a reasonable approach to projections. The market is adequately explained. The numbers are not adequately or reasonably explained as part of a reasonable business performance consistent to the market as explained in the business synopsis. 2. Explanation of the growth or fall in performance between years 1 and 2 Projecting the increase and or decrease in all incomes and costs using metrics based on the market, justified using sources, referenced. Reasonable and logical adjustments to every number in the budget using knowledge of the market from research, fully referenced. A very general explanation to changes in all of the numbers with limited outside referencing or reasonable market understanding. All numbers adjusted in a general way with adequate and reasonable explanation to justify the adjustments. Only some numbers changed and any changes are not adequately explained. 3. Using variance analysis to justify the differences between the initial and optimistic budget. Well-structured, detailed and thorough analysis and projections are explained as a further step from year to year projections. All assumptions should be explained in terms of changes in variances as opposed to solely numerical explanations. Well-structured, analysis and projections are explained as a further step from year to year projections. All assumptions should be explained in terms of changes in variances as opposed to solely numerical explanations. Adequate and reasonable analysis and projections are explained as a further step from year to year projections. All assumptions should be explained in terms of changes in variances as opposed to solely numerical explanations. All projections are explained as a further step from year to year projections. All assumptions should be explained in terms of changes in variances as opposed to solely numerical explanations. The numbers are not represented as variance and / or the changes are adequately explained. 10% of each section is based on the level of English demonstrated within the report. Common skills: assessed (bold) or developed (italics): MANAGING AND DEVELOPING SELF 1.Manages own role and responsibilities 2. Manages own time in achieving objectives. 3.Undertakes personal and career development 4. Transfers skills gained to new and changing situations and contexts. 5.Uses a range of thought processes WORKING WITH AND RELATING TO OTHERS 6.Treats others’ values, beliefs and opinions with respect 7.Relates to and interacts objectively with individuals and groups 8.Works effectively as a member of a team COMMUNICATING 9.Receives and responds to a variety of information 10.Presents information in a variety of visual forms 11.Communicates in writing 12.Participates in oral and non-verbal communication MANAGING TASKS AND SOLVING PROBLEMS 13.Uses information sources 14. Deals with a combination of routine and non-routine tasks 15.Identifies and solves routine and non-routine problems BECOMING NUMERATE AND USING TECHNOLOGY 16.Applies numerical skills and techniques 17.Uses a range of technological equipment and systems Plagiarism: Plagiarism is the act of presenting another’s ideas or words as one’s own. Cheating includes, but is not limited to, the intentional falsification or fabrication of any academic activity, unauthorized copying of another person’s work, or aiding and abetting any such acts. Particular care must be taken when presenting information that has been obtained from an internet site. Should this information not be correctly referenced, then you are guilty of plagiarism and will be penalised accordingly. With respect to projects/assignments, faculty reserves the right to randomly call upon any student and ask them to defend their work orally. Any assignment/exam which is found to contain plagiarism will automatically be awarded a grade of 0, and an e-mail will be sent to the student or the student’s parents/tutors/sponsors. Depending on the circumstances, additional penalties could be imposed (see LRM Academic Regulations, Section 11). Statement of authorship Following the title page of your assignment there should be a page on which you sign a statement that the work included in the assignment is your own work except where appropriately referenced. The following statement should be used: Statement of authorship I certify that this assignment is my own work and contains no material which has been submitted as part of an assignment in any institute, college or university. Moreover, to the best of my knowledge and belief, it contains no material previously published or written by another person, except where due reference is made in the text of the assignment. Signed Name Student number. Page 4 of 4


3. Problem 3 Balance sheet Current assets Cash Short-term investments Receivables, net of allowance for uncollectible accounts of $27, $21, and $15, respectively Inventories Prepaid expenses Total current assets Total current liabilities Income statement Net sales (in millions) 20x3 20x2 20x1 $ 85 S 134 244 334 8 $ 805 $ $ 404 $ 58 S 74 171 108 279 365 27 29 878 $ 855 503 $ 412 250 372 $ 2,807 $ 2,722 $2,210/nThe comparative financial statements of Stage Pools Inc. for 2003, 2002, and 2001 include the following selected data View the comparative financial de Read the requirements Requirement 1. As a financial advisor to an investor of Stage Pools, calculate the information for 2003 and 2002 that would be relevant in determining the company's liquidity position, and specify how each tem of information is relevant to your decision. Start by calculating the curent ratio for 2003 and 2002. Enter the amounts, and then divide to calculate the cument ratics. (Enter amounts in millions as provided to you in the problem statement. Round your answers to two decimal places) Total current assets + Total current liabilities Current ratio 200x2 Next, calculate the acid-test ratio for 2003 and 2002. Enter the amounts, and then divide to calculate the acid-test natics. (Enter amounts in millions as provided to you in the problem statement. Round your answers to two decimal places) Total quick assets + Total current able Acid-test ratio 20012 In this step, calculate the accounts receivable tumover for 2003 and 2012. Enter the amounts, and then divide to calculate the accounts receivable tumover ratios. (Enter amounts in millions as provided to you in the problem statement, XX. Round your answers to two decimal places) Accounts receivable turnover Net sales 2002 20013 Now, calculate the days' sales in average receivables for 2003 and 2002. Enter the amounts, and then divide. (Round your answers to two decimal places) Accounts receivable Number of days 20012 Average net accounts receivable TO: FROM turnover Specity how each item of information is relevant to your decision. Complete the following sentences. The current ratio measures the company's ability to pay the current ratio. The acid-test ratio does not include RE: Days' sales in average receivables Requirement 2. Complete a memo explaining to your client the results of your evaluation, including recommendations that will help Stage Pools improve its liquidity. Complete the following sentences MEMORANDUM Student Name Changes in ratio values from 2002 to 20x3 The addestratos stringent measure of a company's ability to pay The days' sales in receivables tells how long it takes to collect from 2002 to 20 This and is collecting receivables on a timeller basis. Stage Pools can improve its liquidity by Stage Pools because it shows that the company has an its ability to meet its financial obligations and/or


2. Problem 2 November 30, 20X1 December 31, 20X1 February 28, 20X2 March 1, 20X2 May 29, 20X2 December 16, 20X2 December 31, 20X2 Assume that General Mills Canada, famous for Cheerios. Chew snacks, and Yoplait yagut, completed the following selected transactions Read the requirements Sold goods to Sane Inc., receiving a $53,000, three-month, 5.5% note. Made an adjusting entry to accrue interest on the Sane note. Collected the Sane note. Received a 90-day, 6%, $6,500 note from Lan Joli Goût on account. Collected the maturity value of the note plus interest from Lan Joli Goût. Loaned $23,000 cash to Buxton Brands, receiving a 90-day, 8.25% note. Accrued the interest on the Buxton Brands note. Requirements. Record the transactions in General Mi's journal Round interest amounts to the nearest dollar November 30, 2001: Bold goods to Sane ine receiving a $55.000, month 5.5% note (Record debits first, then credits. Exclude explanations from juletries Account Tides Credit November 30, 2001 December 31, 2001: Made an adjusting entry to accrue interest on the Sane note Record debits first, then credits. Exclude explanations from journal entries. Round your answers to the nearest December 31, 201 February 20, 2002: Collected the Same note. (Record debit first, then credits. Exclude explanations from journal entries. Round your answers to the nearest whole dollar) Debit Acc/nMarch 1, 2002: Received a 90-day, 6%, $6,500 note from LanJoll Goût on account (Record debits first, then credits. Exclude explanations from journal entries.) Account Titles Debit Credit March 1, 20x2 May 29, 2002: Collected the maturity value of the note plus interest from Lan Joll Goût (Record debits first, then credits. Exclude explanations from journal entries. Round your answers to the nearest whole dollar) Account Tides Date May 29,20x2 December 16, 2002: Loaned $23,000 cash to Buxton Brands, receiving a 90-day 8.25% note. (Record debits first, then credits. Exclude explanations from journal entries.) Date Account Titles Debit Credi December 16, 202 Date December 31, 2012 December 31, 2002: Accrued the interest on the Budon Brands note. (Record debits first, then credits. Exclude explanations from journal entries. Round your answers to the nearest whole deler) Account Te Debirt General Mills Canada Balance Sheet (Para) As at December 31 2002 Problem ? Credit 210001 Debit Requirement 2. Show what General Mills will report on is comparative classified balance sheet related to those transactions) as of December 31, 2001, and December 31, 2002. Ignore the cash balance because the transactions provided are only selected transactions. (Round your answers to the nearest whole dollar) Credit


1. Problem 1 Data for bank reconciliation a FSA's Cash account shows a balance of $2,199.11 on January 31. b. The January 31 bank balance is $4,021.05. c. The bank statement shows that FSA eamed $38.79 of interest on its bank balance during January. This amount was added to FSA's bank balance. d. FSA pays utilities ($220) and insurance ($110) by EFT. The FSA cheques that did not clear the bank by January 31 are provided in the accompanying table f. The bank statement includes a donation of $875, electronically deposited to the bank for FSA. g. The bank statement lists a $10.90 bank service charge. h. On January 31, the FSA treasurer deposited $16.25, which will appear on the bank statement. 1. The bank statement includes a $294 deposit that FSA did not make. The bank added $294 to FSA's account for another company's deposit. J. The bank statement includes two charges for returned cheques from donors. One is a $405 cheque received from a donor with the imprint "Unauthorized Signature. The other is a nonsufficient funds cheque in the amount of $147.17 received from a dient. BANK: Cheque No. 237 291 293 294 295 296 Subtotal Less: BOOKS: Balance, January 31 Add: Add: Amount $ 46.90 147.00 Less: 508.45 11.17 608.01 9.18 102.56 Frobisher Services Association Bank Reconciliation January 31/nRequirement 2 Requirement 2. Journalize the January 31 transactions needed to update FSA's Cash account include an explanation for each entry Begin by recording the interest earned on the bank balance. (Record debits first, then credits. Select the explanation on the last line of the journal entry table. Round your answers to the nearest cent) Account Titles Dele January 31 Next, record the EFT payment of utilities (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Account Title Debit Credit Date January 31 Credit In this step, record the EFT payment of insurance. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Date Account Te Debit Credit January 31 Next, record the donation that was electronically deposited to the bank for FSA (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Date Account Tides Debit Credit January 31 In this step, record the bank service charge. (Record debits first, then credits. Select the explanation on the last line of the journal entry table. Round your answers to the nearest cent) Debil Cred Account Tides Date January 31 The final journal entry to record is for the nonsufficient funds and "Unauthorized Signature" cheques returned by the bank. Combine both of the returned cheques into one journal entry (Record debits first, then credits. Select the explanation on the last line of the journal entry table. Round your answers to the nearest cent) Account Tides Debit Creek Date January 31/nRequirement 3 Requirement 3. How do a bank account and a Bank Reconciliation help a manager contra cash? How does a bank account help a manager control cash? Complete the following sentences for A bank account helps control cash by providing the company's own records and quickly conectany errors. How does a Bank Reconciation halpa manager control cash? Complete the following sentences corectly accounts for t The Bank Reconciation here that the balance of to report on the 2 Droblom7 The bank provides a detailed list of the company's that managers can compare to and that the bank and book records of cash are comect. The Bank Reconciliation establishes the


For text, Font style: Times New Roman; Font size: 12; Line spacing: 1.5 lines. Include the page number on each page. Reference or bibliography at the end (use APA referencing guidelines). Writing requirements: (b) Develop your points in a clear, logical and succinct manner. Be mindful of the target audience/reader. Use language appropriate to the reader's expected level of knowledge. Free from grammatical and typographical errors. Provide in-text citations when referencing (use APA referencing guidelines). Include less relevant details as an appendix if necessary. Good overall presentation of the report. Question 1 Your friend, George, has invited you to invest in his business started a few years ago. According to him, the business has tripled its revenue since the lifting of Covid 19 restrictions. He anticipated a huge increase in customer demand for the next 2 years. You have requested him to furnish you with the latest set of financial statements. Required: Identify the key financial statements. Describe the information that is reported in these statements and explain why you need to read them before deciding whether to invest. (34 marks) In addition, list other relevant information you wish to request from him. Your answers must not exceed 600 words. Question 2 On 1 January 2024, Tom Lee started a web design firm, Web Solutions (WS). The following are the transactions that occur during the first month of operations. 01 Jan. Tom invested $20,000 cash, and a $6,000 computer in the firm. 01 Jan. Tom received $20,000 from his best friend, Dick as a personal loan to him. 01 Jan. Tom invested the $20,000 which he received from Dick as his own investment in the firm. 01 Jan. 01 Jan. (6 marks) The firm hired a web-designer for $4,500 per month. The firm paid $3,000 cash for January and February rental and another $1,500 for the rental deposit. The rental deposit is refundable. 05 Jan. The firm purchased $1,000 of supplies on account from a supplier. 17 Jan. 25 Jan. The firm billed a customer $7,000 for a job done. The firm received $1,000 cash from another customer as advance payment for a job to be performed in February. 31 Jan. The firm received a telephone bill of $200. Arrangement has been made to pay the bill on 6 February via inter-bank transfer. 31 Jan. The firm paid the web-designer's salary for the month. 31 Jan. An inventory count of supplies showed $300 was still available. 31 Jan. Depreciation of the computer for the month is $500. Required: (a) (b) Analyse the above and record all necessary entries (including adjusting entries). Narration is not required. (26 marks) Present the trial balance of Web Solutions as of 31 January 2024. Question 3 On 1 Dec 2023, Fruits Pte Ltd's trial balance includes the following items: Account Dr ($) Cr (S) 220,000 Accounts Receivables Allowance For Doubtful Accounts 5,000 In the month of December, Fruits Pte Ltd made credit sales of $15,000 and a cash sale of $5,000. The company also collected $18,000 from its accounts receivables in December. (iii) A review of the Accounts Receivables on 1 Dec 2023 reveals the following: Customer Balance Remarks Apple Associates $3,000 Banana Brothers $7,000 (i) (9 marks) The customer has gone bankrupt. 70% is estimated to be uncollectible. An aging analysis of the rest of the accounts receivables indicated that an estimated 3% of these accounts would not be collectible. The company uses the allowance method to value its accounts receivables. Required: (a) (b) Journalise the transactions above including the necessary adjusting journal entries for the company to recognize bad debts. Narration is not required. However, it is important to present all the workings. Round your answers to nearest $. (21 marks) Determine the net realizable value of the accounts receivable as of 31 Dec. (4 marks)


✓ The following amounts summarize the financial position of Little Brown Dog Inc. on May 31, 202X Balance 2560 Cash + Other Information: Required: Accounts Receivable 1280 + Assets Computers (net) 0 + Supplies + Land 400 10400 = During June 202X, the business completed these transactions: June 1: Received a cash investment totalling $4000 in exchange for common shares. 4) Liabilities Accounts Payable 6880 + Note Payable 0 + Salaries Payable 0 Interest Payable 0 + + Shareholders' Equity Retained Earings 4080 June 1: Purchased three computers. The company paid $1000 in cash and took out a bank loan of $4200 to cover the remaining balance owing. The loan bears interest of 10% to be paid on June 1, next year. The computers are expected to last 5 years. June 5: Paid $560 for the current month's office rent. June 9: The business was invoiced for a $2400 purchase of office supplies. June 13: Performed services for a client and received $4000. Common Shares 3680 June 20: Declared and paid a cash dividend of $240. June 23: Received $640 from a customer that was billed last month. June 25: Paid $1600 of a bill received earlier in the month. June 30: Billed a client for services rendered, $2000. June 30: A physical count received that $800 worth of supplies are still on hand. June 30: Paid $640 for an advertising campaign that had been run during the month. Employee salaries were also accrued. Employees work 5 days each week and are paid $2500 in total every other Friday. The month ended on a Wednesday. Employees were last paid 2 weeks ago. + 1) In the past, Little Brown Dog Inc. has used the following accounts on their income statement: Revenue, Depreciation Expense, Interest Expense, Rent Expense, Salaries Expense, Advertising Expense, and Supplies Expense. They use the Dividends account to record dividends. Not all accounts have been used each period. 1) Create all necessary journal entries (including adjusting entries) for the month of June 202X. Place your answer under "Requirement 1" in the "Answer" tab. Note that the dates have been pre-populated. Ensure your journal entries match the appropriate date. Explanations are not required. 2) Analyze the effects of the above transactions on the accounting equation. Place your answer under "Requirement 2" in the "Answer" tab. 3) Prepare the Income Statement for the month ended June 30, 202X. List expenses in decreasing order by amount. Place your answer under "Requirement 3" in the "Answer" tab. Prepare the Statement of Retained Earnings for the month ended June 30, 202X. Place your answer under "Requirement 4" in the "Answer" tab." 5) Prepare the Balance Sheet at June 30, 202X. Place your answer under "Requirement 5" in the "Answer" tab. 6) Using the method outlined in the textbook, joumalize the necessary closing entries for the month ended June 30, 202X. Place your answer under "Requirement 6" in the "Answer" tab. Explanations and dates are not required.


Current Attempt in Progress The following trial balance was taken from the books of Ivanhoe Corporation on December 31, 2025. Cash Accounts Receivable Account Notes Receivable Allowance for Doubtful Accounts Inventory Prepaid Insurance Equipment Accumulated Depreciation--Equip. Accounts Payable Common Stock Retained Earnings Sales Revenue Cost of Goods Sold Salaries and Wages Expense Rent Expense Totals Debit $9,200 40,200 13,500 34,800 4,630 99,700 127,300 50,800 13,000 $393,130 Credit $1,800 At year-end, the following items have not yet been recorded 15,100 10,900 40,200 67,130 258,000 $393,130/nQuestion 1 of 1 Sales Revenue Cost of Goods Sold Salaries and Wages Expense Rent Expense Totals 10 (a) At year-end, the following items have not yet been recorded. G 127,300 50,800 Depreciation on equipment, 10% per year on original cost. Interest at 5% is receivable on the note for one full year. Rent paid in advance at December 31, $5,400 (originally charged to expense). f. Accrued salaries and wages at December 31, $5,720. 13.000 Insurance expired during the year, $1,690. Estimated bad debts of sales revenue, $2,580. b. 6 $393,130 $393,130 2 258,000 No. Account Titles and Explanation Prepare the necessary adjusting entries. (If no entry is required, select "No Entry" for the account titles and enter O for the amour Credit account titles are automatically indented when the amount is entered. Do not indent manually. List all debit entries before cre entries.) Question 1 of 1 - Ex... www Debit VALORANT - / 40 Credit


/n ACCT 370 EXCEL PROJECT: PROJECTING FINANCIAL STATEMENTS ASSIGNMENT INSTRUCTIONS OVERVIEW Common Sized Balance Sheets (Tabs 12), Common Sized Income Statements (Tab 13), Horizontal Analysis Balance Sheets (Tab 14), Horizontal Analysis Income Statements (Tab 15), and Projected Financial Statements (Tabs 16-18) INSTRUCTIONS Continue in the same Excel workbook prepared in Module 4: Week 4, adding the following tabs: О The 12th tab in your Financial Statement Analysis Template must be labeled Common Sized Balance Sheets. ○ О ○ Set-up like the Historical Balance Sheets (Tab 3), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Balance Sheets for the calculations. "Total Assets" should be used as the base for all common sized calculations on the Balance Sheets. Common sized percentages should be calculated for all three historical years presented. See Exhibit A for a partial example of this tab. The 13th tab in your Financial Statement Analysis Template must be labeled Common Sized Income Statements. Set-up like the Historical Income Statements (Tab 2), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Income Statements for the calculations. “Revenue” or “Total Revenue" (depending on your company) should be used as the base for all common sized calculations on the Income Statements. Common sized percentages should be calculated for all three historical years presented. The 14th tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance Sheets. ■ ■ Start by copying and pasting the Historical Balance Sheets from Tab 3 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years. See Exhibit B for an example of this tab. The 15th tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income Statements. Start by copying and pasting the Historical Income Statements from Tab 2 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years. The 16th tab in your Financial Statement Analysis Template must be labeled Projected Income Statements. Three years of projected statements should be included, starting with the most recent year after the company's last issued report. Page 1 of 4 ACCT 370 О ○ ○ The 17th tab in your Financial Statement Analysis Template must be labeled Projected Balance Sheets. Three years of projected statements should be included. Three years of projected statements should be included, starting with the most recent year after the company's last issued report. The 18th tab in your Financial Statement Analysis Template must be labeled Projected Statement of Cash Flows. Three years of projected statements should be included, starting with the most recent year after the company's last issued report. ■ Other information relating to projected tabs: ■ Projections should be based on research performed on your company and its industry. Use historical, trend, ratio data and current and future economic projections as well as information from the company's MD&A to aid in preparing projections. Clearly state your assumptions in a text box at the bottom of each tab. Cite sources for assumptions based on research. The statements should be consistent, reasonable, and accurate. Areas that will be checked for accuracy include: • • • Other instructions: The Balance Sheets should balance for all years presented. Retained earnings should be properly calculated using the prior year's balance, net income, and dividends. The Ending Cash Balance on the Statement of Cash Flows should agree to the Cash Balance shown on the Balance Sheet for the same year. Net Income on the Income Statements should match what is reported on the top of the Statement of Cash Flows (if indirect method is used). The Excel workbook should be professionally formatted. Professional formatting includes: • All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent. Dollar signs are included in the first and last numbers of each column. Subtotals and totals are preceded by a single underline. Totals are followed by a double underline. Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read. All common sized, horizontal analysis, and projection items should be calculated using formulas. Totals and subtotals should also be calculated using formulas. For an example of which cells may need formulas, please see Exhibits A & B. Note: Your assignment will be checked for originality via the Turnitin plagiarism tool. Page 2 of 4 ACCT 370 EXHIBIT A: EXAMPLE COMMON SIZED BALANCE SHEETS (TAB 12, PARTIAL VIEW) (IMPORTANT NOTE: ONLY PARTIAL BALANCE SHEET SHOWN. YOUR BALANCE SHEET SHOULD INCLUDE LIABILITIES AND STOCKHOLDERS' EQUITY AS WELL.) Wendy's Co. Common Sized Balance Sheets As of January 3, 2016, December 28, 2014, and December 29, 2013 ASSETS Current assets: Cash and cash equivalents Accounts and notes receivable Inventories Prepaid expenses and other current assets Deferred income tax benefit Advertising funds restricted assets Total current assets Properties Goodwill Other intangible assets Investments Other assets Total assets Fields using formulas Jan. 03, 2016 Dec. 28, 2014 Dec. 29, 2013 8% 6% 13% 3% 2% 1% 0% 0% 0% 3% 2% 2% 0% 2% 3% 2% 2% 2% 15% 14% 21% 30% 31% 27% 19% 20% 19% 33% 33% 30% 1% 2% 2% 2% 2% 1% 100% 100% 100% EXHIBIT B: EXAMPLE HORIZONTAL ANALYSIS OF BALANCE SHEETS (TAB 14, PARTIAL VIEW) (IMPORTANT NOTE: ONLY PARTIAL BALANCE SHEET SHOWN. YOUR BALANCE SHEET SHOULD INCLUDE LIABILITIES AND STOCKHOLDERS' EQUITY AS WELL.) Page 3 of 4 Wendy's Co. Horizontal Analysis of Balance Sheets As of January 3, 2016, December 28, 2014, and December 29, 2013 $s in thousands ASSETS Current assets: Cash and cash equivalents Accounts and notes receivable Inventories Prepaid expenses and other current assets Deferred income tax benefit Advertising funds restricted assets Total current assets Properties Goodwill Other intangible assets Investments Other assets Total assets Fields using formulas ACCT 370 Jan. 03, 2016 $ Change % Change Dec. 28, 2014 $ Change % Change Dec. 29, 2013 $ 327,216 $ 104,854 4,312 112,788 59,940 22% $ 31,496 43% 267,276 73,358 $ (312,876) -54% $ 580,152 10,473 17% 62,885 (4,495) -51% 8,807 (1,419) -14% 10,226 39,096 53% 73,692 (8,067) -10% 81,759 (73,661) -100% 73,661 (46,545) -39% 120,206 67,399 2,091 3% 65,308 (1,875) -3% 67,183 616,569 54,467 10% 562,102 (360,309) -39% 922,411 1,227,944 (43,294) -3% 1,271,238 105,751 9% 1,165,487 770,781 1,339,587 (51,781) -6% 822,562 (19,982) -2% 842,544 (11,778) -1% 1,351,365 45,585 3% 1,305,780 58,369 95,470 (15,685) -21% 74,054 (9,143) -11% 83,197 30,949 48% 64,521 20,900 48% 43,621 $ 4,108,720 $ (37,122) -1% $ 4,145,842 $ (217,198) -5% $ 4,363,040 Page 4 of 4


About TMA: B326: Advanced Financial Accounting TMA - Spring 2023-2024 V.1 Cut-Off Date: As decided by the Deanship The TMA covers the advanced accounting concepts and practices in the businesses. It is marked out of 100 and is worth 15% of the overall assessment component. This TMA requires you to apply the course concepts. The TMA is intended to: Assess students' understanding of key learning points within chapter 1, 3, 4 and 5. Increase the students' knowledge about the reality of the advanced accounting issues. Develop students' communication skills, such as memo writing, essay writing, analysis and presentation of material. Develop the students' ability to understand and analyze different issues that corporations might face in real world. ➤ Develop basic ICT skills such as using the internet. The TMA requires you to: 1- Review various study chapters in addition to supplementary materials. 2- Conduct a deep information search using the internet and your E-Library. You are expected to use E-library sources to support your answers. A minimum of 3 sources is required. 3- It's imperative that you write your answer using your own words. Plagiarism will be penalized depending on its severity and according to AOU plagiarism policy. 4- You should use a Microsoft Office Word and Times New Roman Font of 12 points. 5- You should use Harvard referencing style for in-text citation and list of references. For Cut-off date: Check LMS Criteria for Grade Distribution: Content Criteria Part A Part B Part C Referencing & E-library Marks 40 30 30 (5) Structure and Presentation of ideas Total marks (5) 100 PART A The TMA Questions: Access Avolta (Previously known as: Dufry) Company website and download: the annual report for 2022. Note: this file is available at: https://www.avoltaworld.com/system/files/2023-03/Annual%20Report_2022.pdf From 2022 annual report, answer the following questions: 1. Determine the total amount of non-controlling interest in 2021 & 2022 and state in which statement it is disclosed and in which section. 2. State the amount of controlling interest share and non-controlling interest share in Dufry Company's profit and Non-controlling interest share in dividends for 2021 & 2022 3. State in details the amounts of goodwill and other intangible assets as it appears in the annual report for 2021 and 2022 4. State Dufry Company acquisitions during 2022 and the aggregated goodwill resulted from these acquisitions. 5. State the amounts of impairment losses of goodwill & other intangible assets in 2022. In addition, state which cash generating unit/division/segment suffered an impairment loss related to goodwill in 2021 and the amounts of that impairment. 6. How did Dufry reflect the 2022 impairment of intangible assets in its financial statements? 7. Dufry Company prepared its consolidated financial statements in accordance with the International Financial Reporting Standards (“IFRS”), as mentioned in its annual report. Assuming that it was not mentioned in the annual report that the company is following IFRS; provide evidence from annual report (related to course subjects studied) that indicate that the company is following IFRS and not following GAAP? Write your answer in the space provided in the following table: 1- 2 - 3- 4- 5- 6- 7- Answer *** Answers not provided in a tabular format will be disregarded Page(s) in Annual report (40 marks) PART B 1) Provide one example from the real world for unsuccessful merger/consolidation/ acquisition case in recent years and state the specific reasons behind their failure. Notes: ■ Do not provide general reasons behind failure [as it will not be considered] ▪ Write your answer in the space provided in the following table: Unsuccessful Merger/Consolidation/ Acquisition Names of the companies And Detailed information about this business combination Reasons for failure * Answers not provided in a tabular format will be disregarded. **Examples dated before 2007 will not be considered. 2) What are the different types of synergies in mergers and acquisitions? ▪ Write your answer in the space provided in the following table: (10 Marks) (10 Marks) Type: Synergies ..... . Synergies Explanation: Synergies * Answers not provided in a tabular format will be disregarded. 3) There are differences between the IFRS and GAAP (after FASB issued ASU 2021-04 to simplify the accounting for goodwill impairment) regarding the following: - Assignment/allocation of goodwill. (i.e., The levels at which goodwill is assigned /allocated) · Impairment of goodwill and test(s) applied and its steps (i.e., Methods of determining impairment of goodwill) How impairment loss is recognized and allocated. (i.e., impairment loss[charge] calculation and allocation) Amortization and impairment of intangible assets other than goodwill Discuss the accounting treatment of the preceding points under GAAP only. (Comparison is not required) ▪ Write your answer in the space provided in the following table: GAAP Assignment/allocation of goodwill Impairment of goodwill How impairment loss is recognized and allocated Amortization and impairment of intangible assets other than goodwill (You must support your answer in this question with quality and up to date references.) (10 Marks) PART C On January 1, 2022, Porto Corporation acquired 80% of the voting stock of Sardinia Corporation for $12,000 when Sardinia had Capital Stock of $5,000 and Retained Earnings of $4,000. On this date, the book value of Sardinia's assets and liabilities was equal to the fair value, except for inventories, which were understated on the books by $500 and were sold in 2022, land which was undervalued by $1,000, and equipment with a remaining useful life of 5 years under the straight-line method which was undervalued by $1,500. Any remainder was assigned to goodwill. Financial statements for the two corporations at the end of the fiscal year ended December 31, 2023 appear in the first two columns of the partially completed consolidation working papers. Porto has accounted for its investment in Sardinia using the equity method of accounting. Porto Corporation owed Sardinia Corporation $100 on open account at the end of the year. Dividends receivable in the amount of $450 payable from Sardinia to Porto is included in Porto's net receivables. Required: 1) Prepare the elimination entries required for consolidation on December 31, 2023. Show all your calculations. 2) Complete the consolidation working papers for Porto Corporation and Subsidiary for the year ended December 31, 2023. 3) State which items have been amortized and which have not in 2023, and why? (30 Marks) Porto Sardinia INCOME STATEMENT Sales 10,000 6,500 Income from Sardinia 960 Cost of Sales (4,000) (3300) Depreciation Expense (1,000) (1000) Other expenses (1,800) (700) Non controlling Interest Share Net income 4,160 1,500 Retained Earnings 1/1 2,510 5,000 Add: Net income 4,160 1,500 Less: Dividends (2,000) (1,000) Retained Earnings 12/31 4,670 5,500 BALANCE SHEET Cash 1,440 1,900 Receivables net 1,100 600 Inventories 1,500 1,200 Land 1,000 1,600 Equipment and Buildings-net 7,500 6,700 Investment in Sardinia Corp 12,320 Goodwill Unamortized Excess TOTAL ASSETS 24,860 12,000 LIAB. & EQUITY Accounts Payable 4,190 1,000 Dividends Payable 2,000 500 Capital Stock 14,000 5,000 Ret. Earnings 4,670 5,500 Nonctl Interest 1/1 Nonctl. Interest 12/31 LIAB. & EQUITY 24,860 12,000 Eliminations Debit Credit Consolidated


Weddle X > 01 Ch 17 HOMEWORK Pr 17-3B www.n X Marketable securities Accounts and notes receivable (net) Inventories Effect of Transactions on Current Position Analysis Data pertaining to the current position of Lucroy Industries Inc. follow: Cash $412,500 167,500 330,000 700,000 50,000 190,000 260,000 325,000 Prepaid expenses Accounts payable Notes payable (short-term) Accrued expenses Required: US hea x Play Jui 47°F Sunny I v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=assignments&takeAssignmentSession Locator=assignment-take&inprogress=false Check My Work 0 more Check My Work uses remaining. Assignment Score: 15.15% 1. Compute (a) the working capital, (b) the current ratio, and (c) the quick ratio. Round ratios to one decimal place. a. Working capital $ 885,000 b. Current ratio X 2.1 Mail- X 1.2 Q Search nfc no X ChatGF X PRE c. Quick ratio 2. Compute the working capital, the current ratio, and the quick ratio after each of the following transactions and record the results in the appropriate columns. Consider each transaction separately and assume that only that transaction affects the data given. Round ratios to one decimal place. Transaction Working Capital a. Sold marketable securities at no gain or loss, $75,000. b. Paid accounts payable, $105,000. c. Purchased goods on account, $135,000. d. Paid notes payable, $120,000. Current Ratio (412,00 X W 17 Cenga x Quick Ratio A Studen X On how to X + ח Email Instructor Save and Exit Submit Assignment for Grading 4x O 9:04 PM 2/23/2024 X 2. Weddle X > Ch 17 HOMEWORK Pr 17-3B www.n X Tepala expenses Accounts payable Notes payable (short-term) Accrued expenses Required: US hea x Play Jui X 47°F Sunny v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=assignments&takeAssignmentSession Locator=assignment-take&inprogress=false 200 190,000 260,000 325,000 Assignment Score: 15.15% 1. Compute (a) the working capital, (b) the current ratio, and (c) the quick ratio. Round ratios to one decimal place. a. Working capital $ b. Current ratio 885,000 Check My Work 0 more Check My Work uses remaining. 2.1 a. Sold marketable securities at no gain or loss, $75,000. b. Paid accounts payable, $105,000. c. Purchased goods on account, $135,000. d. Paid notes payable, $120,000. e. Declared a cash dividend, $140,000. f. Declared a common stock dividend on common stock, $45,000. g. Borrowed cash from bank on a long-term note, $200,000. h. Received cash on account, $145,000. i. Issued additional shares of stock for cash, $550,000. j. Paid cash for prepaid expenses, $15,000. 1.2 Mail- X Q Search PRE c. Quick ratio 2. Compute the working capital, the current ratio, and the quick ratio after each of the following transactions and record the results in the appropriate columns. Consider each transaction separately and assume that only that transaction affects the data given. Round ratios to one decimal place. Transaction Working Capital $ nfc no X $ 00000⁰ $ ChatGF X $ $ Current Ratio 1.9 2.1 (412,00 X W 17 Cenga x Quick Ratio A Studen X On Email Instr Wedxx15k xxx M x Ch 17 HOMEWORK Fr 17-38 Entrance on Cunet Potie Aaysi Dandards frien Cach how to Mystis Ivar Letisk Prod Required 04:2,500 11 700,000 30,000 T X 260.002 323.099 + 1. Camry the way the tweetheque Round rahos to one decimal place Snipping Tool 2. Coming catel, the currente, and the sick to schooling tetenca record the out in the apororits cola Cedera ly he send ration to or desial pl ensartan Working Capital Current Qua Screenshot copied to clipboard and saved Select here to mark up and share. ח 4x O 9:04 PM 2/23/2024 X C. !


Problem 12-02 Chapter 12: Assignment-Bond Fundamentals and Valuation Back to Assignment Attempts 2. Problem 12-02 eBook Average/3 Problem 12-02 An 8.5% coupon bond issued by the state of Indiana sells for $1,000. What coupon rate on a corporate bond selling at its $1,000 par value would produce the same after-tax return to the investor as the municipal bond if the investor is in a. the 15% marginal tax bracket? Do not round intermediate calculations. Round your answer to two decimal places. b. the 25% marginal tax bracket? Do not round intermediate calculations. Round your answer to two decimal places. c. the 20% marginal tax bracket? Do not round intermediate calculations. Round your answer to two decimal places. Problem 12-03 Grade it Now Save & Continue


CHAPTER 12: 16 PROBLEMS Problem 12-01 Chapter 12: Assignment-Bond Fundamentals and Valuation Back to Assignment 1. Problem 12-01 eBook Average/2 Problem 12-01 What would be the initial offering price for the following bonds (assume $1,000 par value and semiannual compounding)? Do not round intermediate calculations. Round your answers to the nearest cent. a. A 14-year zero-coupon band with a yield to maturity (YTM) of 14%. $ b. A 24-year zero-coupon bond with a YTM of 10% $


Chapter 08: Assignment -Equity Valuation Back to Assignment Attempts 1. Problem 8-11 ellook Average/2 Problem 8-11 Assume a company has a payout ratio of 46 percent, a profit margin of 6 percent, a cost of equity of 13 percent and a growth rate of 3.5 percent. Do not round intermediate calculations. Round your answers to three decimal a. What is the forward price-sales multiple? b. What is the trailing price-sales multiple?


Chapter 08: Assignment-Equity Valuation Back to Assignment 7. Problem 8-10 Average/1 Problem 8-10 You are building a free cash flow to the firm model. You expect sales to grow from $1.4 billion for the year that just ended to $1.68 billion five years from now. Assume that the company will not become any more or less efficient in the future. Assume that the company will grow at a constant rate for 5 years, and then at a constant rate of 3.213729% for year 6 and onward after that. Use the following information to calculate the value of the equity on a per-share basis. a. Assume that the company currently has $420 million of net PPBE b. The company currently has $140 million of net working capital. c. The company has operating margins of 12 percent and has an effective tax rate of 30 percent. d. The company has a weighted average cost of capital of 11 percent. This is based on a capital structure of two-thirds equity and one-third debt. e. The firm has 1 million shares outstanding. Do not round intermediate calculations. Round your answer to the nearest cent. Grade it Now Save & Continue


Chapter 08: Assignment Equity Valuation Back to Assignment S. Problem 8-07 Problem 8-67 The current risk-free rate is 4 percent and the market risk premium is 5 percent. You are trying to value ABC company and it has an equity bets of 0.7. The company earned $3.00 per share in the year that just ended. You expect the company's earnings to grow 4 percent per year. The company has an ROE of 10 percent. a. What is the value of the stock? Do not round intermediate calculations. Round your answer to the nearest cent. 5 b. What is the present value of the growth opportunity? Do not round intermediate calculations. Round your answer to the nearest cent Average/2 Chapter 08: Assignment Equity Valuation Back to Assignment Attempts S. Problem 8-07 ellook Average/2 Grade it Now Save & Continue Continue without saving Problem 8-07 The current risk-free rate is 4 percent and the market risk premium is 5 percent. You are trying to value ABC company and it has an equity bets of 0.7. The company earned $3.00 per share in the year that just ended. You expect the company's earnings to grow 4 percent per year. The company has an ROE of 10 percent. a. What is the value of the stock? Do not round intermediate calculations. Round your answer to the nearest cent. b. What is the present value of the growth opportunity? Do not round intermediate calculations. Round your answer to the nearest cent Grade it Now Save & Continue Continue without saving


No Question Found for“Financial Accounting”

we will make sure available to you as soon as possible.